Reply
Frequent Visitor
Posts: 2
Registered: ‎09-25-2017

Help with Month over Month Change % Measure

Hi All
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

Highlighted
Frequent Visitor
Posts: 2
Registered: ‎09-25-2017

Re: Help with Month over Month Change % Measure

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