How to find Difference between 2 or more rows considering MoM difference

[NikitaA]

Hi All,

I am new to Power BI and I was preparing a report where I need to show MoM difference of various Stages which also includes filtering different products (like Housing, retail, corporate).. Is there a way to find the difference and put multiple filters please??

So in the below table I was looking for difference between January and February figure and so on...

Stages	January 2022	February 2022	March 2022	April 2022	May 2022
1. Expired	200,000	210,000	220,000	230,000	240,000
2. Bankrupt	2,000,000	2,100,000	2,200,000	2,300,000	2,400,000
3. Forbearance	800,000	810,000	820,000	830,000	840,000
4. PD Deterioration	12,000,000	12,100,000	12,200,000	12,300,000	12,400,000

[amitchandak]

@NikitaA , the month or data date should be on rows, not on columns as shown in the sample in the original data. Then you can have date from month

Datevalue("01 " & [Month Year]) 

and use time intellignece

You also need unpivot of power query on above data

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Using data table you can get MOM

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s