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. [ Ссылка ]
Watch next 💥👇
==============
Power Query vs. Power Pivot vs. Power BI - differences explained - [ Ссылка ]
Power BI & Data jargon explained - [ Ссылка ]
💥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 - [ Ссылка ]
#PowerBI
When to add a MEASURE and when to add a Column in DAX
Теги
chandoochandoo.orgpower biwhen to use powerbi measuresmeasure vs column power bimeasure vs calculated columnspower pivot sumx exampleiterator functions in daxdax sumxcalculated columns in dax examplecan I replace a calculated column with measure in power bihow to replace columns with measures in daxmeasure vs column best practicepower bi interview questionspower pivot interview questionsdax questions in interviewswhen to use a measure vs. column