Forum Discussion
Calculate variance between two Matrix in Power Bi
I have two matrixes in power Bi
user can choose a forecast from point in time and select which month to see the results.
from 1st slicer they choose the first creation date (year and Month)
then they choose which month to see the forecasts for in the 1st matrix
same for the 2nd matrix for a different point in time
so, we end up with two matrixes.
how can I calculate the variance between these two matrixes?
Thanks
results
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
3 Replies
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/1447523The 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.
