Description

"80 Solved Cases of Statistics in DAX Language" is the third release in a series of four quick guides designed to address multiple scenarios using the DAX language.

At the moment, our collection includes:

- 180 Solved Cases in Dax Language (Published in September 2021).
- 90 Solved Cases On Time Intelligence In DAX (Published in January 2022).
- 60 Solved Cases on Finance in Dax (in press).

Following the practical approach of the previous guides, this new edition is aimed at Microsoft Power BI users and presents a total of 85 statistical case studies solved with DAX. The selected examples seek to address the most common situations in the business environment.

All DAX code provided in this guide can be tested using the file "80_solved_cases_of_statistic_in_dax.pbix", available for download at the following link:

Finally, it should be noted that the statistical analysis presented in this book is based on time periods. Therefore, it is essential to have a Calendar Table in the model. The code needed to create such a table is found in Case 1 of this work.