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

preview_player
Показать описание
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 📙👉
==============

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

💥Need to learn Power BI in a hurry👉
===============================

#PowerBI
Рекомендации по теме
Комментарии
Автор

great sir....looking forward to seeing more DAX function and relationship 😆please make seprate video for fact and dim table relationship...🙏plz

ksbharat
Автор

Great video
Aggregation values - use measures
Row wise values - use columns

ramnaslai
Автор

the best thing about chandoo is he always gives practice data to follow along...always appreciated ✊

Rj
Автор

The best video on the measures and column distinction and similarities.With great examples.👍

sonyset
Автор

Thank you so much Chandoo! This video explains the difference simply and elegantly. Thanks again!!!

KarthikRamSubbiah
Автор

This is helpful... Calculated column consume a lot memory of if the table is big and eventually it slow the performance of the dashboard. This also should be kept in mind.

TheMak
Автор

Thank you so much! 🙏 This video answers all my doubts.

sapnaantara
Автор

Hi Chandoo. Thanks for the great advice! When first learning, sometimes it is confusing which way to turn. Your tips are very helpful :)) Thumbs up!!

wayneedmondson
Автор

Thank you for the explanation at the best😄

Srikanth-mznl
Автор

super great stuff @Chandoo! Very much appreciate your videos and sessions! thx!

cherianiype
Автор

Nimmantha Meshtru namge school alli sikkidre eshtu chennagirtittu...!!

vaijayantigulve
Автор

Great info exactly what I was looking for a very clear too!!

ratnoinamaew
Автор

This was extremely clear and helpful. Thank you!! @CHANDOO

dreama_x
Автор

Great video...really explicit. I've gleaned so much from watching your videos and I'm so glad I'm subscribed to your Channel. I wish you'd make more videos on power bi explaining DAX concepts like filter context, row context, context transition, time intelligence functions etc.

nonoobott
Автор

Excellent Chandoo and thank fot sharing.

joseagundis
Автор

Thank you sir for the great help on this topic!

vasudevan
Автор

Thanks for this. I can use DAX but I can see some DAX uses fields and some only allow measures. An explanation about this would be great.

Bondoz
Автор

Thank you so much for your very clear and useful explanation!

forestsunrise
Автор

This is nice. Thanks a lot for sharing

sabitichristopher
Автор

Thanks a lot for your support and explanation your awesome

mohamedzarkany