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)
Thank you for responding but
isn't appending both table combines all the records old+new
After the suggested step, the table 1 will have added all the record of table 2.
You you then use table 1 because it will have the full records.