Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
@Anonymous wrote: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 1ID Product Week Cost
1 Gum 1 1001 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!
Hi,
Please check this solution
https://community.powerbi.com/t5/Desktop/Finding-differences-between-tables/m-p/328736#M146789
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |