Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Jgrohows
Frequent Visitor

Matrix with multiple date Columns

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.

Jgrohows_0-1678380849615.png

 

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.

 

MonthyYearDate<0 Days1-119 Days120-359 Days360+ DaysTotal AR
December2022Thursday, December 1, 2022125000125
October2022Saturday, October 1, 202212512500250
November2022Tuesday, November 1, 20221251251250375
September2022Thursday, September 1, 20221251251251251000
1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.