Hi all,
I have a requirement where I need to compare two tables of data and would like to highlight differences. The majority of the data in both tables will be the same; however, there can be deleted rows or additional rows in either table and I would like to create a query that would highlight this. In addition, if the row exists in both tables but there is a difference in a column value, I would need to highlight this too.
For example, in the data set below there are three differences between the two tables.
1. Addition of 2 chocolate product rows
2. Week 2 of the gum products has been removed
3. Week 2 of the mint product is 40
Table 1
ID Product Week Cost
1 Gum 1 100
1 Gum 2 100
2 Mint 1 50
2 Mint 2 50
Table 2
ID Product Week Cost
1 Gum 1 100
2 Mint 1 50
2 Mint 2 40
3 Choc 1 120
3 Choc 2 120
I am looking to find a way in PowerBI where I can produce an output that shows me the changes in a similar way to below. I have been struggling with finding a way to do this and was wondering if anyone had any suggestions or if this was even possible?
Expected output
ID Product Week Cost
1 Gum 2 100
2 Mint 1 40
3 Choc 1 120
3 Choc 2 120
Any help would be much appreciated!
