Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |