topic Calculate variance between two Matrix in Power Bi in DAX Commands and Tips

Calculate variance between two Matrix in Power Bi

Anonymous — Wed, 26 Apr 2023 01:29:47 GMT

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

Re: Calculate variance between two Matrix in Power Bi

lbendlin — Sun, 30 Apr 2023 18:30:48 GMT

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

Re: Calculate variance between two Matrix in Power Bi

Anonymous — Mon, 01 May 2023 00:00:43 GMT

thanks Will do

Re: Calculate variance between two Matrix in Power Bi

PBIdashboards — Tue, 02 Jun 2026 02:16:33 GMT

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.