DAX dynamic Percent change based on Calendar slicer.
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
