Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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