Table.RemoveMatchingRows - filter remaining rows by type of differenct

[avitalo1]

Hi,

I have two tables I'm comparing using Table.RemoveMatchingRows and removing matching rows.
The comparison is for 5 columns (name of unit, unique id, created date, end date, type of unit)
The new table has all the rows with differances between them.

Is there a way to filter on type of difference (either in m or dax) and create a report for rows which differ in the unit name, rows which differ in the created date etc. 

Or should I create a seperate Table.RemoveMatchingRows table for each column comparison? 

Happy to try any ideas you may have

thanks

Avital

[lbendlin]

Or should I create a seperate Table.RemoveMatchingRows table for each column comparison? 

yes. there is not higher intelligence in these comparisons. You have to explain to Power Query what you want to compare.