Тёмный

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

Chandoo
Подписаться 630 тыс.
Просмотров 78 тыс.
50% 1

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/measur...
Watch next 💥👇
==============
Power Query vs. Power Pivot vs. Power BI - differences explained - • The truth about Power ...
Power BI & Data jargon explained - • Top 20 Data & BI terms...
💥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-...
#PowerBI

Наука

Опубликовано:

 

30 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 73   
@ksbharat3806
@ksbharat3806 2 года назад
great sir....looking forward to seeing more DAX function and relationship 😆please make seprate video for fact and dim table relationship...🙏plz
@chandoo_
@chandoo_ 2 года назад
Hey Atul. You are welcome. I suggest watching the DAX & BI terminology video next - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-a906b80lCE8.html
@ramnaslai2980
@ramnaslai2980 Год назад
Great video Aggregation values - use measures Row wise values - use columns
@Rj12922
@Rj12922 9 месяцев назад
the best thing about chandoo is he always gives practice data to follow along...always appreciated ✊
@KarthikRamSubbiah
@KarthikRamSubbiah 2 года назад
Thank you so much Chandoo! This video explains the difference simply and elegantly. Thanks again!!!
@sonyse2t5
@sonyse2t5 2 года назад
The best video on the measures and column distinction and similarities.With great examples.👍
@chandoo_
@chandoo_ 2 года назад
Glad you liked it!
@forestsunrise26
@forestsunrise26 Год назад
Thank you so much for your very clear and useful explanation!
@ratnoinamaew7822
@ratnoinamaew7822 5 месяцев назад
Great info exactly what I was looking for a very clear too!!
@Chancelier1269
@Chancelier1269 Год назад
THANK YOU SIR VERY SIMPLE AND CLEAR.
@shivakanth5601
@shivakanth5601 9 месяцев назад
Very clearly explained.. Thank you!
@vasudevan3195
@vasudevan3195 8 месяцев назад
Thank you sir for the great help on this topic!
@dreama_x
@dreama_x 4 месяца назад
This was extremely clear and helpful. Thank you!! @CHANDOO
@AllinOne-kp8bp
@AllinOne-kp8bp 11 месяцев назад
Thanks chandoo for this useful video
@mohamedzarkany
@mohamedzarkany Год назад
Thanks a lot for your support and explanation your awesome
@rishigupta2342
@rishigupta2342 2 года назад
Very Good Explanation!!!
@cherianiype
@cherianiype 2 года назад
super great stuff @Chandoo! Very much appreciate your videos and sessions! thx!
@chandoo_
@chandoo_ 2 года назад
Glad you like them!
@mahendragupta9599
@mahendragupta9599 11 месяцев назад
You Are great Chnadoo !!
@nonoobott8602
@nonoobott8602 2 года назад
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.
@chandoo_
@chandoo_ 2 года назад
Thanks Nono. I run a detailed course on writing and using DAX for business reporting. Check it out here and email me to join - chandoo.org/wp/power-bi-play-date/ For something free, check out my 15 DAX examples live stream video (2+ hours) - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eCuPRqQNe6Y.html
@ixushardware
@ixushardware 3 месяца назад
Thanks very much, very clearly explained
@TheMak1529
@TheMak1529 2 года назад
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.
@chandoo_
@chandoo_ 2 года назад
Bingo... That said, sometimes they offer better DAX writing experience (especially when you are learning or building your first few models)
@keerthimanirajan2435
@keerthimanirajan2435 Год назад
Thank you Chandoo, i have a question, if in the table the quantity is not summed up, so when we pull the country field and quantity field in x axis against revenue(new column created by units price * quantity) in y axis for a bar chart, the quantity will be showing as count of quantity and there is no option for change it to sum of quantity. what to do in such a condition. pls help
@wayneedmondson1065
@wayneedmondson1065 2 года назад
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!!
@chandoo_
@chandoo_ 2 года назад
You are welcome Wayne.
@Srikanth-mz9nl
@Srikanth-mz9nl 4 дня назад
Thank you for the explanation at the best😄
@chrism9037
@chrism9037 2 года назад
Thanks for sharing, Chandoo!
@chandoo_
@chandoo_ 2 года назад
You are welcome Chris :)
@vaijayantigulve4883
@vaijayantigulve4883 10 месяцев назад
Nimmantha Meshtru namge school alli sikkidre eshtu chennagirtittu...!!
@gondalaprasad
@gondalaprasad Год назад
Hi, A long pending doubt which I am unable to find. If we have a table on a website we can directly pull it from Power query but lets assume we have hyperlinks in column 1 of the initial table which leads to further tables, how can we fetch them and handle in dashboard? Please Please suggest. Thank you.
@joseagundis1
@joseagundis1 2 года назад
Excellent Chandoo and thank fot sharing.
@chandoo_
@chandoo_ 2 года назад
My pleasure
@shriram8088
@shriram8088 2 года назад
Very Helpful chandu, Thank you !
@chandoo_
@chandoo_ 2 года назад
My pleasure 😊
@sabitichristopher
@sabitichristopher 2 года назад
This is nice. Thanks a lot for sharing
@chandoo_
@chandoo_ 2 года назад
Glad you liked it
@chuksoflavian8871
@chuksoflavian8871 Год назад
Hey chandoo , I need to ask , do you know how I can get the total value of each row in a table in power bi? I have a table with about 500 rows and 50 columns , I need to get the total values of each row .
@amanmalalo8653
@amanmalalo8653 2 года назад
Helpful. Thanks for sharing
@chandoo_
@chandoo_ 2 года назад
My pleasure
@we.visuals
@we.visuals Год назад
THANK YOU!!!
@FRANKWHITE1996
@FRANKWHITE1996 2 года назад
Thanks for sharing! 👍
@chandoo_
@chandoo_ 2 года назад
Thanks for watching!
@user-xp3xd6pt3l
@user-xp3xd6pt3l 11 месяцев назад
Thank you Chandoo Sir, Your video is really informative, Please give us some power bi real project
@RajeshBachuRadhika
@RajeshBachuRadhika 2 года назад
Awesome Sir.. Thanks for the video..as you promised in recent live stream you did this.. love your commitment 🥰
@chandoo_
@chandoo_ 2 года назад
You are welcome Rajesh. Live streams are great way to get new ideas for me.
@RajeshBachuRadhika
@RajeshBachuRadhika 2 года назад
@@chandoo_ Sir, could to please do a video on "Whatif" parameter in PowerBI. or please share the link if any. Thanks in advance
@chandoo_
@chandoo_ 2 года назад
I did a live stream on this last month. Here is the video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jjT_yor0NuA.html
@RajeshBachuRadhika
@RajeshBachuRadhika 2 года назад
@@chandoo_ Thanks a lot Sir..
@Bondoz007
@Bondoz007 2 года назад
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.
@chandoo_
@chandoo_ 2 года назад
You are welcome Linda. I have another longer video on DAX that explains the concepts. See it here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eCuPRqQNe6Y.html
@anilgondi1008
@anilgondi1008 Год назад
Sir Can we create a Measure, Table, Column in Import mode and Direct Query
@brij26579
@brij26579 2 года назад
👌 super
@EverythingAboutLife117
@EverythingAboutLife117 10 месяцев назад
Please can you do the thing you just did in power BI on Power query???? I would really appreciate it........I am having difficulty in replicating it in Power Query.
@canirmalchoudhary8173
@canirmalchoudhary8173 2 года назад
Seeing again to get clarity.
@akshunithy
@akshunithy Год назад
Can I get average of Total Sales 2??
@frenan82
@frenan82 2 года назад
thanks!
@chandoo_
@chandoo_ 2 года назад
Welcome!
@shivasai25
@shivasai25 2 года назад
Hello sir, Really ur videos are insightful Is there any scenarios to Master DAX by practicing daily .
@chandoo_
@chandoo_ 2 года назад
Thanks Shiva... I have many DAX videos on the channel Watch them and practice. All the best. Playlist - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-n7gAJMBdJ8k.html
@sandipansarkar9211
@sandipansarkar9211 Год назад
finished pra cticing
@rohitshekhar6582
@rohitshekhar6582 2 года назад
Hi Sir, I am a Chartered Accountancy student in India. I have also enrolled myself in Data Science and Business Analytics course which is yet to start as I aspire to be an internal auditor and data analytics and visualization plays a big role in this domain. I have always wished to come to New Zealand for work but right now I have no clue how i will be able to make it and if it the right course for me to work there. Can you please help me with this? TIA
@chandoo_
@chandoo_ 2 года назад
Thanks Rohit. I am not an expert on NZ job market. I suggest looking at the immigration NZ website and NZ job sites such as seek / trademe for what is available. All the best.
@shubhampilare4663
@shubhampilare4663 2 года назад
Hello sir.,can you teach DAX functions?
@chandoo_
@chandoo_ 2 года назад
Sure. I just did. But if you want more DAX wisdom, check out this video for 15 DAX examples - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eCuPRqQNe6Y.html
@danishnawaz3651
@danishnawaz3651 5 месяцев назад
Plz make Video for below Formula "Power Query", Video Time Fram is Max 10mint 1. List.RemoveMatchingItems 2. List.ReplaceMatchingItems 3. List.TransformMany 4. List.ReplaceValue 5. List.PositionOfAny 6. List.PositionOf 7. List.NonNullCount 8. List.Intersect 9. List.Durations 10. List.Difference 11. List.FindText 12. List.InsertRange 13. List.Union
@chandoo_
@chandoo_ 5 месяцев назад
That was very specific. You can search up these functions and figure it out yourself. Happy learning.
@mrrishiraj88
@mrrishiraj88 2 года назад
Good day
@chandoo_
@chandoo_ 2 года назад
Have a nice day
@mihisarawijethunga6601
@mihisarawijethunga6601 2 года назад
❤❤❤❤❤✌✌✌
@chandoo_
@chandoo_ 2 года назад
😍😍😍
Далее
I Built a EXTREME School Bus!
21:37
Просмотров 6 млн
This ~NEW~ Excel Function is Shockingly Powerful!
9:37
Combine Excel Sheets with *this* simple formula
4:44
DAX Fridays #204: Slice by the results of a measure
10:59
Measures vs. calculated columns in DAX and Power BI
6:00
How to Soldering wire in Factory ?
0:10
Просмотров 6 млн
НЕ БЕРУ APPLE VISION PRO!
0:37
Просмотров 370 тыс.
Battery  low 🔋 🪫
0:10
Просмотров 13 млн