Create a new column by using two different table values

[Anonymous]

I am new to power BI. I have 2 tables. One is primary and other one is backup. Both the table has progress columns. What I want is new column which is the difference of those two columns. I tried few options but couldnt find a solution.

My end goal is, I want to create a graph based on each task progress. Any suggestions will be helpful

One of the option I tried.

New Column =

var JoinCol = 'Table1'[Task]

var NewCol = CALCULATE((Table1[Progress]-Table2[Progress]),'Table2'[Task]=JoinCol)

return NewCol

[dax]

Hi @Anonymous , 

If possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

@Anonymous 

do you have relationships between tables?

In the most common case and 1:1 relations it should be the simpliest option like

New Column = Ta2le1[Progress] - Table1[Progress]

[amitchandak]

@Anonymous , Try like

New Col in Table 1= 'Table1'[Progress] - sumx(filter('Table2','Table1'[Task] = 'Table2'[Task] ),'Table2'[Progress])

or
New Col in Table 2= 'Table2'[Progress] - sumx(filter('Table1','Table1'[Task] = 'Table2'[Task] ),'Table1'[Progress])