Thank you for a wonderful, instructive video. Subscribed! Not only did you cover how to break down a complicated problem into many individual steps, but the amount of DAX functions covered in one video was amazing. I've take a lot of Power BI training videos and they typically focus on one or 2 DAX functions at a time. As much as that is helpful, I find that I know a decent amount about the mechanics of individual DAX functions, but not always how to piece them all together into a solution. Your training style is unique in that regards as a fairly new student of PBI. One minor point that I thought I'd share. I recently took a DAX Studio training video over at SQLBI and they mentioned that if you want to have EVALUATE return a scalar value instead of a table, just wrap the condition inside curly braces and then you do not have to use the ROW function. Step 1 as an example: EVALUATE -- ROW("Result", COUNTROWS(Sales)) {"Result", COUNTROWS(Sales)}
Another awesome video. I was just playing with the logic for getting the top sellers from your other video so this was perfect. I love the step by step approach using dax studio. Your explanations and communication are top notch. Well done.
Thank you for a comprehensive walkthrough. Subscribed! It also explains how to take a DAX Query and get it to the point where it returns a scalar value which means we can use the logic in a measure.
This video helped out my DAX skills tremendously. Thank you so much for taking the time to put it together. Please post more videos like this involving other functions and problems. So incredibly helpful.
Andre must have missed this video , yet a wonderful instructive video. not only on clearly explaining some complex DAX functions but learned at the same time how to make use of DAX studio. recently installed Tabular Editor 3. but missing an instructive video how to properly use it. kind regards roger
Please do a DAX course. I have bought so many online courses advertising themselves as "advanced dax" but I have never seen some of these functions before.
Hi Andre! At 10:46 you say you have to use calculate to get the right results. i pulled calculate on both the sales calc & the distinctcount of products. received the same answer as using calculate
well, sum would see an entire table, I don't remember exactly what the point was but if you don's use calculate in some cases SUM will not work the way you would expect
It was one of the best video on DAX i've ever seen, too bad the instructor never smiles
:)
Thank you from a newbie by breaking it down.
somebody get this guy an MVP already
:)
Agreed . Not one MVP given him 497 MVPs... This was a great video indeed
@@jazzista1967 ty sir :)
Very helpful video. I loved the step by step breakdown and explanation of a lot of different table functions. Thank you.
I like how you get straight to the point and explain the topic well. Thank you for creating this video.
From now on YOU are my favorite PBI channel!! Keep up the good work
Wow, thanks!
Thank you for a wonderful, instructive video. Subscribed! Not only did you cover how to break down a complicated problem into many individual steps, but the amount of DAX functions covered in one video was amazing. I've take a lot of Power BI training videos and they typically focus on one or 2 DAX functions at a time. As much as that is helpful, I find that I know a decent amount about the mechanics of individual DAX functions, but not always how to piece them all together into a solution. Your training style is unique in that regards as a fairly new student of PBI.
One minor point that I thought I'd share. I recently took a DAX Studio training video over at SQLBI and they mentioned that if you want to have EVALUATE return a scalar value instead of a table, just wrap the condition inside curly braces and then you do not have to use the ROW function.
Step 1 as an example:
EVALUATE
-- ROW("Result", COUNTROWS(Sales))
{"Result", COUNTROWS(Sales)}
ty sir, that's correct, you gotta use row() or some other way to turn the result as a table
Another awesome video. I was just playing with the logic for getting the top sellers from your other video so this was perfect. I love the step by step approach using dax studio. Your explanations and communication are top notch. Well done.
ty sir, glad you found this format to be useful.
Thank you for a comprehensive walkthrough. Subscribed! It also explains how to take a DAX Query and get it to the point where it returns a scalar value which means we can use the logic in a measure.
Thanks for the sub!
This video helped out my DAX skills tremendously. Thank you so much for taking the time to put it together. Please post more videos like this involving other functions and problems. So incredibly helpful.
Thanks, will do!
Thanks for taking the time to record your videos, much appreciated!
you are very welcome!
From Chile, really really deep video explanation ¡
ty sir, glad you liked it
Andre
must have missed this video , yet a wonderful instructive video. not only on clearly explaining some complex DAX functions but learned at the same time how to make use of DAX studio.
recently installed Tabular Editor 3. but missing an instructive video how to properly use it.
kind regards
roger
The best video that i saw about those subjects!
ty sir!
Andre... this was an epic video and a very elegant demonstration of these table functions specially the trouble shooting part . Thanks a lot!
Ty sir!
Thanks a lot, unfortunately I can like only once. This video helped a lot.
Glad it helped!
Excellent content and logical progression to explain some difficult and useful concepts.
ty sir!
Please do a DAX course. I have bought so many online courses advertising themselves as "advanced dax" but I have never seen some of these functions before.
This is an excellent video
ty sir!
absolutely wonderful ! , great explanation 👍👍👍👍👍
Glad you liked it!
Great video, well explained. Many thanks.
Glad you enjoyed it!
Awesome, thank you so much
You're very welcome!
How cool is that! Many thanks!
You are welcome!
solid as always!!😍😍😍
ty sir
Hi Andre!
At 10:46 you say you have to use calculate to get the right results. i pulled calculate on both the sales calc & the distinctcount of products. received the same answer as using calculate
well, sum would see an entire table, I don't remember exactly what the point was but if you don's use calculate in some cases SUM will not work the way you would expect
@@KnowledgeBankPro yes you need calculate in item 5 but not item 4. but why?
@@GregKramerTenaciousData i will take a look tomorrow and get back to ya