Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a dataset that I can use for a company. I made a matrix visual, like below.
In the rows, there is an option to drill down to a daily level.
There are relative periods, default is for the selected period. Last Year refers to the same period last year. This information is already in the dataset.
I want to have a "Third" column where I display the difference between Default and Last Year.
I already tried a solution where I made new measures for each measure where I calculate the difference, but when drilling down PowerBi gave a message that it's low on memory.
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
15 | |
7 | |
6 |