Time Intelligent Measures

In this lesson we will be using DAX to create time intelligent measures. Here are the formulae you will use in class

• PM Revenue (M) = CALCULATE([Revenue (M)], PREVIOUSMONTH('Date'[Date]))

• MTD Revenue Var (M) = [Revenue (M)] - [PM Revenue (M)]

• MTD Revenue Var % = DIVIDE([MTD Revenue Var (M)], [Revenue (M)])

• PM COGS (M) = CALCULATE([COGS (M)], PREVIOUSMONTH('Date'[Date]))

• MTD COGS Var (M) = [COGS (M)] - [PM COGS (M)]

• MTD COGS Var % = DIVIDE([MTD COGS Var (M)], [COGS (M)])

• PM Gross Margin (M) = [PM Revenue (M)] - [PM COGS (M)]

• MTD Gross Margin Var (M) = [Gross Margin (M)] - [PM Gross Margin (M)]

• MTD Gross Margin Var % = DIVIDE([MTD Gross Margin Var (M)], [Gross Margin (M)])

If you skipped previous lessons, you can start by downloading the pbix file.