Forum Discussion
Column comparison
You should be able to do this in M code, just a simple join (Merge) query.
How and where can I do that exactly? I was able to join the two tables, but the result was incorrect
You could use Merge queries feature.
Sample data:Product name for Jan
Product Name A B C D E F G H I J K L Product name for Feb
Product Name B D E F G Y I J K M Edit query>Merge queries
Results
For the null row which indicates the product names disappear, for the rows that have values, it indicates the product names are still in the list.
Reference
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/
Regards,
Charlie Liao
Hey Charlie,
thank you so much for your reply! I tried to put whatever comes out of the in a new table with merge as new query (My PowerBi is in German, not sure whether translation is correct) because when I just tried to merge the queries this appeared:
This is the code that is displayed: = Table.NestedJoin(#"March",{"Names"},#"April",{"Names"},"NewColumn",JoinKind.LeftOuter)
So I don't really understand why PowerBi is just adding a new column? And there is only the expression "Table" in it?
When i put it in a new empty query it worked better, but now of course I can't really see the names that disappeared, but only the names that matched in both columns...
= Table.NestedJoin(#"March",{"Names"},#"April",{"Names"},"NewColumn.1",JoinKind.LeftOuter)