DAX dynamic Percent change based on Calendar slicer.

[datajunkie_29]

Hello all,

I'm trying to write a measure that calculates % change (MoM) based on the Date slicer. And the start date % change must show 0 irrespective of data.

Currently, this is how the visual is displayed:

DAX measures:

1. Prior Month Price Per Unit $ = CALCULATE([Net Price Per Unit], PREVIOUSMONTH('Calendar'[Date]))  

2. Average Price Change % = DIVIDE([Net Price Per Unit] - [Prior Month Price Per Unit $] , [Prior Month Price Per Unit $] )

3. Price Change % = CALCULATE([Average Price Change %], PREVIOUSMONTH('Calendar'[Date])) + [Average Price Change %]

How can I show Jan/or any starting month as 0 and then MoM calc based on the start date and end date selected from the slicer.

Any help is appreciated! Thank you

[FreemanZ]

hi @datajunkie_29

NewMeasure =
VAR _startdate =
CALCULATE(
    MIN('Calendar'[Date]),
    ALLSELECTED('Calendar')
)
RETURN
IF(
    MAX('Calendar'[Date]))=_startdate,
    0,
    [Price Change %]
)

[datajunkie_29 · Accepted solution]

Hello @FreemanZ , 

The above solution worked for me, after changing MAX to MIN in the return function. I guess there was a typo in the above code.

NewMeasure =
VAR _startdate =
CALCULATE(
    MIN('Calendar'[Date]),
    ALLSELECTED('Calendar')
)
RETURN
IF(
    MIN('Calendar'[Date]))=_startdate,
    0,
    [Price Change %]
)

Thank you for your help! Appreciate it 🙂  

[datajunkie_29]

Hello @FreemanZ ,

Thank you for your response. I tried the above measure and unfortunately, the start month still shows percent change number (attached below)