Comprehensive DAX Table Functions Tutorial (GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN +more) скачать в хорошем качестве

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

Link to blog and tutorial materials: https://businessintelligist.com/2020/... I have tried to do this before one temp table function at a time, but I think I need to try something different In this video, we will go from the simplest table functions like ROW() to more sophisticated ones like GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN and a few others. I think that unless you go through several of the table functions in the same video/tutorial, making the logic more complicated with every step, it is hard to compare and contrast those functions as well as being able to understand when and which function makes more sense. This tutorial starts with a simple sales data set and then we go to DAX Studio where we go through thirteen steps from simple to more complex trying to figure out how to calculate Crazy Sales. What is a Crazy Sale? Well, that is type of an outlier sale where we already had a good week of selling more than $8k of different products and we sold at least four out of our five products that week …AND that single sale of the product that day was at least 20% of the entire week's sales. So, we are selling a lot more of that product in a day that we should normally be. The best way to go through the tutorial is to download the PowerBI Desktop File. Open the Desktop file, launch the DAX studio, load the Tutorial Scrip and then go through each step in the video and DAX studio at the same time. My believe is that it will definitely help you get a very good understanding of these functions.