topic Re: DAX dynamic Percent change based on Calendar slicer. in DAX Commands and Tips

DAX dynamic Percent change based on Calendar slicer.

datajunkie_29 — Fri, 12 May 2023 01:18:13 GMT

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

Re: DAX dynamic Percent change based on Calendar slicer.

FreemanZ — Fri, 12 May 2023 02:18:24 GMT

hi datajunkie_29

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

Re: DAX dynamic Percent change based on Calendar slicer.

datajunkie_29 — Fri, 12 May 2023 14:24:06 GMT

Hello FreemanZ ,

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

Re: DAX dynamic Percent change based on Calendar slicer.

datajunkie_29 — Mon, 15 May 2023 15:06:13 GMT

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 🙂