Subtracting Grand Totals from two separate Tables

[shiranti2000]

Hello everyone

I have created two tables in BI which are coming from two different spreadsheets. One spreadsheet provides estimated Manpower for a project in 2023 and the other one we have just made recently with the refreshed information. 

A BI sample table is shown below.

Power BI gives you the option to give you the total at the end. Now if we have two such tables in BI with different totals, is there a way to calculate the variance (difference) of the two? so this would be a variance row where 2024 variance would be 218.81- 16 and so on,

[v-zhouwen-msft · Accepted solution]

Hi @shiranti2000 ,

For your question, you can try the 'SUM' function.

Use the following DAX expression to create measures:

_2024 = 
VAR _a = SUM(Table1[2024])
VAR _b = SUM(Table2[2024])
RETURN _b - _a

_2025 = 
VAR _a = SUM(Table1[2025])
VAR _b = SUM(Table2[2025])
RETURN _b - _a

Final output