Sales PM := CALCULATE ( [Total Sales], DATEADD ( 'Dim_Date'[Date], -1, MONTH ) ) Sales MoM Variance := [Total Sales] - [Sales PM] Sales MoM % := DIVIDE ( [Sales MoM Variance], [Sales PM] )