Create new column with last month's value for a given category

[Anonymous]

I want to create a new column that consists of the previous month's value for a given Category.

For example, if the data I'm given is as follows:

Month	Category	Price
1/1/2024	Car	1000
1/1/2024	House	2000
2/1/2024	Car	900
2/1/2024	House	2000
2/1/2024	Insurance	600
3/1/2024	Car	800
3/1/2024	House	2000
4/1/2024	Car	700
4/1/2024	House	2000
5/1/2024	House	2500
6/1/2024	Car	600
6/1/2024	House	2000

I would want the new column to look like this:

Month	Category	Price	Previous Month Value
1/1/2024	Car	1000
1/1/2024	House	2000
2/1/2024	Car	900	1000
2/1/2024	House	2000	2000
2/1/2024	Insurance	600
3/1/2024	Car	800	900
3/1/2024	House	2000	2000
4/1/2024	Car	700	800
4/1/2024	House	2000	2000
5/1/2024	House	2500	2000
6/1/2024	Car	600
6/1/2024	House	2000	2500

If there is no data for the previous month for the given category, the "Previous Month Value" should be null.

[ryan_mayu · Accepted solution]

@Anonymous 

Column = maxx(FILTER('Table','Table'[Category]=EARLIER('Table'[Category])&& 'Table'[Month]=EDATE(EARLIER('Table'[Month]),-1)),'Table'[Price])