Calculating the variance percentage on last month

  1. The syntax for a Variance Percentage is:
    Variance Percentage = ([New value]-[Last value]/[Last value])

  2. In DAX, it would look like this. Use this measure in OrderDetails.

Total Sale Monthly Var % = DIVIDE ( ( [Total Including Tax] - [Total Including Tax Last Month] ), [Total Including Tax Last Month], BLANK () )

Totol Sales Monthly Var %

We’ve used the DIVIDE function. This handles divide by 0 errors with the 3rd parameter.
DIVIDE([Numerator], [Denominator], [Value when divide by 0 error])
In this case we’re setting the value to BLANK()


3. Format this measure as a percentage by selecting the measure.
Under Measure Tools tab > Click on the % symbol
Format Measure





End of Lab 3