Forum Discussion

akathuri01's avatar
akathuri01
Regular Visitor
2 years ago
Solved

Relating data from 3 tables

Hi All, I have a scenario where i am doing a reconilliation between 2 data sets and need to populate comments from a 3rd data set incase results are not true. Below is an example where i have my mas...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi akathuri01 

    Based on your needs, I have created the following table.





    You can use the following Measure to get the matching status of the two tables:

    MEASURE = 
IF (
    ISBLANK ( SELECTEDVALUE ( Table1[Name - Table -1] ) )
        || ISBLANK ( SELECTEDVALUE ( Table1[Ticker -table 1] ) )
        || ISBLANK ( SELECTEDVALUE ( Table2[Name - Table -2] ) )
        || ISBLANK ( SELECTEDVALUE ( Table2[Ticker -table 2] ) ),
    "Removed from group",
    IF (
        SELECTEDVALUE ( Table1[Ticker -table 1] )
            = SELECTEDVALUE ( Table2[Ticker -table 2] )
            && SELECTEDVALUE ( Table1[Name - Table -1] )
                = SELECTEDVALUE ( Table2[Name - Table -2] ),
        "Match",
        "Name changed"
    )
)

     



    Create a new table, and then make the following settings in the filter:

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

If the Ticker is as simple as shown, you could standardise table1 and table2 by making a table of Ticker Numbers 1..x (where x is the largest ticker from table1 and table2 ) and using that and Left Join Merge on both tables.

You then do a Merge inner join of these 2 tables because they both have rows for all Ticker numbers.
Then do a Merge Inner join on table3

--