Forum Discussion
Column comparison
Hi everybody,
i'm completely unfamiliar with PowerBI and just started using ist two days ago. I am getting a list of product names every month. That list is constantly growing and already to big to open it in Excel. I tried to open it with Notepad ++ and split it into different sheets but that doesn't work, either...
What I want to do is, upload the lists that come in every month and compare it to one from the month before and see which names are still in the list and which ones disappeared. Is that possible? I tried to do it with a Related function and joins, but it won't work out...
Can anyone help me out?
6 Replies
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
