Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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 |
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
53 | |
53 | |
36 | |
33 |
User | Count |
---|---|
80 | |
73 | |
45 | |
45 | |
43 |