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

Опубликовано: 29 Сентябрь 2024
на канале: 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