Comprehensive DAX Table Functions Tutorial (GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN +more) 

Thank you from a newbie by breaking it down.

It was one of the best video on DAX i've ever seen, too bad the instructor never smiles

I like how you get straight to the point and explain the topic well. Thank you for creating this video.

somebody get this guy an MVP already

Very helpful video. I loved the step by step breakdown and explanation of a lot of different table functions. Thank you.

From now on YOU are my favorite PBI channel!! Keep up the good work

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.

Thanks for taking the time to record your videos, much appreciated!

From Chile, really really deep video explanation ¡

The best video that i saw about those subjects!

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 a lot, unfortunately I can like only once. This video helped a lot.

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.

Andre... this was an epic video and a very elegant demonstration of these table functions specially the trouble shooting part . Thanks a lot!

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

Excellent content and logical progression to explain some difficult and useful concepts.

Awesome, thank you so much

This is an excellent video

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.

Great video, well explained. Many thanks.

absolutely wonderful ! , great explanation 👍👍👍👍👍

How cool is that! Many thanks!

solid as always!!😍😍😍

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