When to add a MEASURE and when to add a Column in DAX

Published: 09 November 2021
on channel: Chandoo
85,990
1.5k

Not sure when to create a measure or add column in Power BI? In this easy video, learn why & when you should make each of them, best practice advice with examples.

Topics in this video ⏱👉
====================
0:00 - Introduction to the model
0:30 - Simple rule for "when to make a measure" with example
1:51 - When to create a column with example
3:38 - How to decide when either a measure or column can do the job?
5:15 - Avoiding columns with "Iterator" measures (SUMX example)
6:29 - Back to square one - Measure vs. Column
7:25 - Closing remarks

Sample file 📙👉
==============

If you want to practice the Measure vs. Add column concepts, here is a practice file. https://files.chandoo.org/pbix/measur...

Watch next 💥👇
==============

Power Query vs. Power Pivot vs. Power BI - differences explained -    • The truth about Power BI (and how to ...  
Power BI & Data jargon explained -    • Top 20 Data & BI terms every data ana...  

💥Need to learn Power BI in a hurry👉
===============================
If you want to learn and master Power BI quickly, please consider enrolling in my online Power BI class. Full info here - https://chandoo.org/wp/power-bi-play-...

#PowerBI


Watch video When to add a MEASURE and when to add a Column in DAX online without registration, duration hours minute second in high quality. This video was added by user Chandoo 09 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 85,990 once and liked it 1.5 thousand people.