Forum Discussion
Calculate variance between two Matrix in Power Bi
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
thanks Will do
PBIdashboardsPost Patron
The challenge with two separate matrices and slicer-driven point-in-time comparison is that DAX needs to reconstruct both contexts simultaneously, it gets complex fast.
One option that sidesteps the complexity entirely: Flexa Tables (AppSource) handles period-over-period comparison as a built-in feature. Users pick two time points to compare directly in Power BI Service no need to maintain two separate matrices or write DAX for the variance. The comparison column appears instantly.