Data Modelling and DAX

This set of challenges will involve creating a set of base measures for Actuals/Budget and key metrics such as Revenue, Gross Profit and Net Margin.

We will also look at “dynamically” formatting the calculations – e.g. depending on whether it is a percentage or currency value, and whether the Income Statement is showing consolidated values across multiple organisation units (in which case it will show values in reporting currency) or a single organisational unit (with values formatted according to the local currency e.g £ or €)