Month on Month change

[chinmayjain132]

Supposing we have this month over month calculation. If I put a 2023 and 2024 slicer and choose 2024 in that, Jan 2024 starts showing 0% change. I understand that 2024 has been selected and the previous value corresponds to 2023.. but I want to show that change in January 2024 also. How to do that?  

[chinmayjain132]

I'm using PREVIOUSMONTH to get a month over month calculation. Should I use it with in combination with PREVIOUSMONTH or instead of PREVIOUSMONTH? 

[lbendlin]

instead of. PREVIOUSMONTH will use the entire previous period, which is most likely not what you want.

[chinmayjain132]

Tried EDATE but it doesn't show the right value. Seems like its summing up for 2023 if I put a filter for 2024

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

use EDATE(x,-1)  in your measure.