Similar Tables and their relationships

[Enkei]

Hello Everyone,

I have 3 tables , all of them have 98 rows and 6 columns but only 2 of the column datas are different. 

I want to find the difference in that 2 columns and plot a visual to see the difference. 

Also I want to create relationships between these tables (created from 3 csv files).

can someone please help????

[Icey · Accepted solution]

Hi @Enkei ,

If the other 4 columns are the same, you can also create a column to combine the 4 columns and create relationships based on the created columns.

Or use merge like so: Relationship in Power BI with Multiple Columns - RADACAD.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

Hello @Enkei ,

Can you please clarify your requirement in detail?

If the data structure is same, can't you consider appending these tables together and removng duplicates if it solves your purpose?

For your query to get the difference in two tables, here is the generic Power Query code:

let
    addedT1_= List.Difference(Table1[ID], Table2[ID]),
    addedT2_= List.Difference(Table2[ID], Table1[ID]),
    TChanges_ = Table.AddColumn(Table.SelectRows(Table.SelectRows(Table2, each not List.Contains(addedT2_, [ID])), each _ <> Table1{[ID = [ID]]}), "Change description", each "Change in table 2 compared to table 1", type text)
    
in
    TChanges_

i