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. files.chandoo.org/pbix/measure%20vs%20column.pbix
Watch next 💥👇
==============
Power Query vs. Power Pivot vs. Power BI - differences explained - youtu.be/6lzdovy1uCw
Power BI & Data jargon explained - youtu.be/a906b80lCE8
💥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 - chandoo.org/wp/power-bi-play-date/
#PowerBI
- When to add a MEASURE and when to add a Column in DAX ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Adding Columns & DAX Measures in Power BI Desktop | Microsoft Power BI Desktop for Business ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
- Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column ( Download)
- ADDCOLUMNS - DAX Guide ( Download)
- Multiple DAX Measure updates in DAX Query View Yes, Please! ( Download)
- DAX Fridays! #143: ADDCOLUMNS and SUMMARIZE | Create virtual tables ( Download)
- Use Measures in Columns of a Matrix Visual ( Download)
- Power BI Basics: Tutorial Part 4 - DAX, Adding columns and Measures ( Download)
- What is Measure in POWER BI |KSR Datavizon |DAX in Power BI | DAX DAY ( Download)
- Power BI Dax Function Calculate to Conditionally Calculate and create New Measures ( Download)
- Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
- Test your Power BI DAX measures in DAX Studio ( Download)
