- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Compare 2 tables and highlight the differences
Hello Guys,
I am new to PowerBI and don't have the expertise to implement the following into a query:
I need to compare 2 tables and based on unidentical values put those values in a seperate table. Right now for a simple overview I created 2 tables and a mockup:
This one is called "Table1":
This one is called "Table2":
And this is the table i want to have after comparing the 2 tables:
As you can see, in table1 and table2 the first 3 rows contain a value that is not identical (sorry for the german text), now the 4th row is identical and therefore not in the mockup included. In the mockup, the row, the column and both values should be displayed for a simple overview.
I know this is probably a lot to implement, but I'd already be grateful for some ideas on how to implement it.
Thanks a lot in advance!
Yours faithfully,
Jonas
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@JonasSonderman - try this pbix file and let me know if this works for you.
pls don't hesitate to give kudos to useful posts and mark solution as accepted. Many Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@JonasSonderman - try this pbix file and let me know if this works for you.
pls don't hesitate to give kudos to useful posts and mark solution as accepted. Many Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Great solution, I've made it work on my case! Just another question: The actual files that I am going to use will be much larger, do you have any idea on how to show the row number of the values that arent identical. Like a column named "row" first so you don't have to manually search for it?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-04-2024 04:53 AM | |||
09-15-2024 03:18 PM | |||
02-16-2024 10:05 AM | |||
10-11-2023 06:18 PM | |||
06-13-2024 09:13 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |