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.
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.
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) - ua-cam.com/video/eCuPRqQNe6Y/v-deo.html
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.
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
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 .
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.
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
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
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.
![[UA] NAVI vs MOUZ | BO5 | IEM Rio 2024](http://i.ytimg.com/vi/CMBYk0cbGoA/mqdefault.jpg)
great sir....looking forward to seeing more DAX function and relationship 😆please make seprate video for fact and dim table relationship...🙏plz
Hey Atul. You are welcome. I suggest watching the DAX & BI terminology video next - ua-cam.com/video/a906b80lCE8/v-deo.html
Great video
Aggregation values - use measures
Row wise values - use columns
the best thing about chandoo is he always gives practice data to follow along...always appreciated ✊
Thank you so much Chandoo! This video explains the difference simply and elegantly. Thanks again!!!
The best video on the measures and column distinction and similarities.With great examples.👍
Glad you liked it!
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.
Bingo... That said, sometimes they offer better DAX writing experience (especially when you are learning or building your first few models)
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!!
You are welcome Wayne.
Nimmantha Meshtru namge school alli sikkidre eshtu chennagirtittu...!!
Thank you! i needed to learn this, glad i found it! thanks!
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.
You are welcome Linda. I have another longer video on DAX that explains the concepts. See it here - ua-cam.com/video/eCuPRqQNe6Y/v-deo.html
You are really a great teacher.
Great info exactly what I was looking for a very clear too!!
THANK YOU SIR VERY SIMPLE AND CLEAR.
super great stuff @Chandoo! Very much appreciate your videos and sessions! thx!
Glad you like them!
Very clearly explained.. Thank you!
Thank you so much! 🙏 This video answers all my doubts.
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.
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) - ua-cam.com/video/eCuPRqQNe6Y/v-deo.html
This was extremely clear and helpful. Thank you!! @CHANDOO
Thank you Chandoo Sir, Your video is really informative, Please give us some power bi real project
Thank you so much for your very clear and useful explanation!
Thanks chandoo for this useful video
Thank you for the explanation at the best😄
You Are great Chnadoo !!
Thank you sir for the great help on this topic!
Excellent Chandoo and thank fot sharing.
My pleasure
Very Helpful chandu, Thank you !
My pleasure 😊
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.
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
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 .
Very Good Explanation!!!
Thanks a lot for your support and explanation your awesome
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.
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
That was very specific. You can search up these functions and figure it out yourself. Happy learning.
Hello sir,
Really ur videos are insightful
Is there any scenarios to Master DAX by practicing daily .
Thanks Shiva... I have many DAX videos on the channel Watch them and practice. All the best.
Playlist - ua-cam.com/video/n7gAJMBdJ8k/v-deo.html
Thanks for sharing, Chandoo!
You are welcome Chris :)
This is nice. Thanks a lot for sharing
Glad you liked it
Awesome Sir.. Thanks for the video..as you promised in recent live stream you did this.. love your commitment 🥰
You are welcome Rajesh. Live streams are great way to get new ideas for me.
@@chandoo_ Sir, could to please do a video on "Whatif" parameter in PowerBI. or please share the link if any. Thanks in advance
I did a live stream on this last month. Here is the video - ua-cam.com/video/jjT_yor0NuA/v-deo.html
@@chandoo_ Thanks a lot Sir..
Sir Can we create a Measure, Table, Column in Import mode and Direct Query
Helpful.
Thanks for sharing
My pleasure
THANK YOU!!!
Anyway chandu sir is great
Thanks for sharing! 👍
Thanks for watching!
Seeing again to get clarity.
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
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.
👌 super
finished pra cticing
thanks!
Welcome!
Hello sir.,can you teach DAX functions?
Sure. I just did. But if you want more DAX wisdom, check out this video for 15 DAX examples - ua-cam.com/video/eCuPRqQNe6Y/v-deo.html
Can I get average of Total Sales 2??
❤❤❤❤❤✌✌✌
😍😍😍
Good day
Have a nice day