Module 3: Mastering DAX for Financial Metrics and Time Intelligence
Click the Mark Complete button to finish the lesson or topic.
- Description: Now that we have our data loaded into Power BI, we need to create the table relationships and a set of base measures for Actuals/Budget and key metrics such as Revenue, Gross Profit and Net Margin. We will also leverage time intelligence to show MTD, QTD or YTD values depending on a slicer selection.
-
- Outcome: After this module you will know how to write measures in DAX, including understand the power of time intelligence to create dynamic calculations
