Forum Discussion
Solved
Power bi Calculated table
There are two table i.e table1 area number 1 909 2 908 3 907 6 897 4 876 5 878 and table2 area number 9 441 10 232 5 3423 2 233 11 1213 1...
Found a solution :-
Z_TABLE =
VAR _old =
FILTER (
'table1',
'table1'[AC_NO - Copy]
<>CALCULATE (
SELECTEDVALUE('table2'[AC_NO - Copy]),
ALLEXCEPT (
'table1','table1'[AC_NO - Copy]
)
)
)
VAR _new = 'table2'
RETURN
UNION(_old,_new)
Hi.
You should go to power query / transform
Then select APPEND QUERIES
and choose this way in picture
But appending both tables cause duplicates entries of both tables