Forum Discussion
jppuam
Helper V
Helper VLEFT OUTER JOIN not working
Hello, i've a table A with the follow: code_ID department costs 1 chemistry 100 2 math 200 3 sociology 300 4 ...
If the matching is to be based on all 3 columns:
NewTable = EXCEPT ( Table1, Table2 )Regards
Jos_Woolley
Solution Sage
Solution SageHi,
New query, merge as new:
You can then delete the final column resulting from this query.
If the operation is to consider not just the code_ID column then select all columns as required when performing the merge, for example:
Regards
Regards
jppuamHelper V
Helper VI was trying to do it with DAX, i'll try it like you said.
JP