09-25-2017 10:33 AM
Can anyone help me create a measure for "month over month % change"? I have all the $ in a column as
"Claims [transaction amount]". I have a dates map column too and have them linked.
Desired result: current month transaction amount - previous month transaction amount / prev month transaction amount.
So I got the desired result for current month $ - prev month $, using =sum(claims[trans Amount])-Calculate(Sum(Claims[trans amount]),Parallelperiod(Claims[date],-1,month)).
But how can I factor in "divide by previous month" in this measure? to get my % change
09-25-2017 11:16 AM
I have made some progress but now getting #NUM in my pivot table column. The measure tested correct.
Current measure used:
=SUM(Claims[Transaction Amount])/CALCULATE(SUM(Claims[Transaction Amount]),PARALLELPERIOD(Claims[Date],-1,MONTH))-1