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.
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.
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 .
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
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.
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) - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
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 - th-cam.com/video/a906b80lCE8/w-d-xo.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 ✊
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)
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!
The sad music got me 😂 never though I would laugh with a Power BI teaching video
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.
Sir Can we create a Measure, Table, Column in Import mode and Direct Query
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.
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 .
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 - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
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
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! i needed to learn this, glad i found it! thanks!
You are really a great teacher.
THANK YOU SIR VERY SIMPLE AND CLEAR.
Great info exactly what I was looking for a very clear too!!
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 - th-cam.com/video/n7gAJMBdJ8k/w-d-xo.html
Very clearly explained.. Thank you!
super great stuff @Chandoo! Very much appreciate your videos and sessions! thx!
Glad you like them!
Thank you Chandoo Sir, Your video is really informative, Please give us some power bi real project
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.
Can I get average of Total Sales 2??
Thank you so much! 🙏 This video answers all my doubts.
Excellent Chandoo and thank fot sharing.
My pleasure
Thanks for sharing, Chandoo!
You are welcome Chris :)
Thank you sir for the great help on this topic!
Thanks chandoo for this useful video
Thank you so much for your very clear and useful explanation!
Thank you for the explanation at the best😄
You Are great Chnadoo !!
Very Helpful chandu, Thank you !
My pleasure 😊
Very Good Explanation!!!
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.
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) - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
This is nice. Thanks a lot for sharing
Glad you liked it
Thanks a lot for your support and explanation your awesome
This was extremely clear and helpful. Thank you!! @CHANDOO
Seeing again to get clarity.
Helpful.
Thanks for sharing
My pleasure
Thanks for sharing! 👍
Thanks for watching!
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 - th-cam.com/video/jjT_yor0NuA/w-d-xo.html
@@chandoo_ Thanks a lot Sir..
THANK YOU!!!
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 - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
Anyway chandu sir is great
finished pra cticing
👌 super
thanks!
Welcome!
Good day
Have a nice day
❤❤❤❤❤✌✌✌
😍😍😍