Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello. I've scoured the message boards for an answer to this with no luck so I thought I'd post on here. I have a matrix with two rows and two columns. I'd like to (instead of a total) have percent change year over year for rows and a percent change quarter over quarter for the columns. I could do this in two seconds in Excel, but it seems impossible in Power BI. Any help is appreciated.
Example Matrix:
HI @benaford,
You can write a measure formula to extract the current category fields as condition to filter and calculate the difference.
In Dax expression, the fiscal date may not directly work as common date values. For this senecio, you can use current fiscal date to find out correspond fact date and calculate to get the previous date. Then you can use this as condition to find out previous fiscal date to calculate.
If you are confused about coding formula, can you please share some dummy data to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |