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) - ruclips.net/video/eCuPRqQNe6Y/видео.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.
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.
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
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
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 .
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.
![Megan Thee Stallion - Roc Steady (feat. Flo Milli) [Official Video]](http://i.ytimg.com/vi/HozPPyqW0dY/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 - ruclips.net/video/a906b80lCE8/видео.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 ✊
The best video on the measures and column distinction and similarities.With great examples.👍
Glad you liked it!
Thank you so much Chandoo! This video explains the difference simply and elegantly. Thanks again!!!
Nimmantha Meshtru namge school alli sikkidre eshtu chennagirtittu...!!
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)
super great stuff @Chandoo! Very much appreciate your videos and sessions! thx!
Glad you like them!
Great info exactly what I was looking for a very clear too!!
Thank you! i needed to learn this, glad i found it! thanks!
You are really a great teacher.
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.
The sad music got me 😂 never though I would laugh with a Power BI teaching video
Thank you so much! 🙏 This video answers all my doubts.
Very clearly explained.. Thank you!
Excellent Chandoo and thank fot sharing.
My pleasure
Thanks chandoo for this useful video
THANK YOU SIR VERY SIMPLE AND CLEAR.
Thank you so much for your very clear and useful explanation!
You Are great Chnadoo !!
This was extremely clear and helpful. Thank you!! @CHANDOO
Very Helpful chandu, Thank you !
My pleasure 😊
Thank you sir for the great help on this topic!
Thanks for sharing, Chandoo!
You are welcome Chris :)
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 - ruclips.net/video/eCuPRqQNe6Y/видео.html
Thank you for the explanation at the best😄
Thanks very much, very clearly explained
Very Good Explanation!!!
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) - ruclips.net/video/eCuPRqQNe6Y/видео.html
Thanks a lot for your support and explanation your awesome
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 - ruclips.net/video/jjT_yor0NuA/видео.html
@@chandoo_ Thanks a lot Sir..
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 Sir, Your video is really informative, Please give us some power bi real project
Helpful.
Thanks for sharing
My pleasure
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.
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
THANK YOU!!!
Sir Can we create a Measure, Table, Column in Import mode and Direct Query
Thanks for sharing! 👍
Thanks for watching!
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.
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 .
Anyway chandu sir is great
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 - ruclips.net/video/n7gAJMBdJ8k/видео.html
👌 super
Can I get average of Total Sales 2??
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.
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 - ruclips.net/video/eCuPRqQNe6Y/видео.html
finished pra cticing
Good day
Have a nice day
❤❤❤❤❤✌✌✌
😍😍😍