Forum Discussion
Create a report showing all differences between two tables
I'm trying to create a report/new table that shows the difference and what those differences are. I've spent a few days and looked at many articles and I just can't seem to get it.
Table 1
Table 2
Output should be:
Name, "Issue", Table 1, Table 2
This would only apply to Names that exist or have mismathed data.
Example:
Blowoff, InheritancePath, \BaseEF\Monoshell\, \BaseEF\Tracking\Tracking Lot Context\
Bracing, InheritancePath, \BaseEF\Monoshell\, \BaseEF\Tracking\Tracking Lot Context\
Critical EF Noti....., Existence, False, True
Anyone know of any way to get something close to this? There are many more columns and I know each will probably need to be custom.
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
I create a sample pbix file(see attachment) for you, please check whether that is what you want.
1. Add a custom column with table name for Table 1 and Table 2 in Power Query Editor
= Table.AddColumn(#"Changed Type", "Tables", each "Table 1")2. Append these two tables
3. Create a matrix visual (Rows: Name Columns: Tables Values: First InheritancePath)
Best Regards