Find the Difference of each value vs previous month

[ilcaa72]

i am struggling trying to create this simple calculation... i want to subtract the current months MatchedRate to the previous months match rate for each BankID. i want to create a Matrix with Dates in Columns and BankID in Rows showing the differences rom month to month for each bank

for starting at line 2, the Diff would be -.1

here is a link to the file. https://1drv.ms/u/s!Av69y58QJYzRjyE4igUTbHkFchba

[v-frfei-msft · Accepted solution]

Hi @ilcaa72,

I update the formula like this, then we can get the result as we excepted.

Monthly Difference = IF(ISBLANK(DATEADD(test[Date],-1,MONTH)),BLANK(),
SUMX(test,MAX(test[MatchedRate]))
- 
CALCULATE(SUMX(test,MAX(test[MatchedRate])),DATEADD(test[Date],-1,MONTH))
)

Also, Please check the pbix as attached.

https://www.dropbox.com/s/jbc01xatesb0giy/Difference%20in%20Month.pbix?dl=0

Regards,

Frank