Matrix with multiple date Columns

[Jgrohows]

Hello! 

I am trying to create a Matrix that looks like below.  I got as far as getting the rows sorted, but i cant seem to get the dates into the columns.

I basically want to show the following columns

1 - Current Month (CM)

2- Previous Month (PM)

3- CM less PM

4- Current month from Previous Year (CMPY)

5- CM less CMPY

Please note i would like the columns to be dynamic, so that if i enter data with date of 2/1/2023, the other columns will update appropriately. 

Please let me know if there is anything else i an provide to assist. Below is a sample of the data.

Monthy	Year	Date	<0 Days	1-119 Days	120-359 Days	360+ Days	Total AR
December	2022	Thursday, December 1, 2022	125	0	0	0	125
October	2022	Saturday, October 1, 2022	125	125	0	0	250
November	2022	Tuesday, November 1, 2022	125	125	125	0	375
September	2022	Thursday, September 1, 2022	125	125	125	125	1000

[lbendlin]

Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Power BI Community

Make sure you really want to spend that effort, and you can handle the maintenance.