PowerBI has been the preferred BI tool for a large number of companies in recent times. As the tools get adopted we have seen a number of reporting scenarios from Basic excel porting to complex Machine Learning models. Regardless of how you plan to utilize PowerBI it is important to learn and understand the DAX formulas available in PowerBI.
In this series we aim to cover 30 DAX Formulas we encounter regularly when working on projects and feel these are common enough to be useful for interviews and projects alike.
Before we start the below set of link take you to the appropriate DAX formula, some DAX Formula need to be in conjunction with others. The example and screenshots used in this series are based on the WorldWideImporters database. Which can be downloaded and restored here.
We are using the May 2020 release of PowerBI so the screens may look slightly different but the Formula being used will be the same regardless of version.
You can use the below Index to navigate to the appropriate post.