Compare 2 tables and highlight the differences

[JonasSonderman]

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 

[Manoj_Nair · Accepted solution]

@JonasSonderman - try this pbix file and let me know if this works for you. 

Power BI file 

pls don't hesitate to give kudos to useful posts and mark solution as accepted. Many Thanks

[JonasSonderman]

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?