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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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