Previousmonth Month and Row Context

[Anonymous]

Hey Community, i have a question regarding time intelligence and row context. 

I want to build a monthly growth measure using the following formulas: 

- [Bestand] --> (Its a Running total, but thats not really relevant)

- [Bestand Vormonat] =CALCULATE([Bestand],PREVIOUSMONTH(Datum[Datum]))

- Bestand - Bestandswachstum (Laufend) = [Bestand]-[Bestand Vormonat]

This should give me the monthly growth of [Bestand]. 

This works out just fine, if i use a matrix or table with MONTHS as rows and therefore having a filter context on month. 

Problem (or not so much because it works as intended, but: 

- If i use YEARS as the row context for a matrix or table, the monthly growth switches to a YOY calculation. 

See the attached jpg.

From my point of view, this behaviour seems to be somehow inutitiv and delivers the expected result, however im not so sure, how this works, bevause Previousmonth should result in 1 Month shift backwards....

Thx for your help

[amitchandak · Accepted solution]

@Anonymous , Previousmonth take start date , so try using datesmtd

last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

Please refer my video where I explained this diff

https://www.youtube.com/watch?v=1KkoJehRVeg

There 2 video before this that explain TI in details