Forum Discussion

chuckm4614's avatar
chuckm4614
Frequent Visitor
8 years ago

Compare two sets of data

Hello All - I'm new to PowerBI and I apologize in advance if this in the forum already and I missed it!

 

I have 3 different data sets (Table_AVI, Table_IND, Table_Zip) and each have a FullName column.  I need to compare the FullName columns in Table_IND and Table_Zip to the Table_AVI and tell me which Names are in both or possibly in all three. 

 

If there is a match, would it be possible to add a column to Table_AVI to show if the match was from Table_IND & or Table_Zip?

 

If this is possible, I wouild also like to perform the same using the Phone and also an email.

 

Thanks in advance for the help!

 

Chuck

Need Help
Tutorial Requests

4 Replies

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Got to be some tricks you can do in Power Query for this one. You could:

    - hack down IND and Zip to a single column with just the names

    - add a custom column to IND that just says IND in every row and one in Zip that just says Zip

    - Merge IND and Zip together on the name, add a column with conditional logic saying if the IND column's blank then Zip, else if the Zip column's blank then IND, else Both

    - Merge that into AVI

     

    Probably more efficient ways to do this but that should work

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Assuiming you have defined the relationship properly, you can try the below calculated column.

    IF( Table_AVI[Name] = EARLIER(RELATED( Table_IND[Name]) , "Match in IND", "No Match")

     

    IF( Table_AVI[Name] = EARLIER(RELATED( Table_ZIP[Name]) , "Match in ZIP","No Match")

     

    Thanks

    Raj