Forum Discussion

Protocoder's avatar
Protocoder
New Member
4 years ago
Solved

2 way table comparison with 3 columns

Hello Experts, I am trying to do 2 way comparison of tables with one column in one sheet and 2 columns in another sheet.    Sheet 1: ABC123 ACD2343 Arnold Abigail  Barbara  Dian...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Protocoder 

     

    You can try the following methods.

    Column:

    Look1 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column1])
    Look2 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column2])

    This is the result of the matching of column 1 of Table 1 and column 2 of Table each. Does this meet your expectations? If not, please tell us what you expect the result to be?

     

    Best Regards,

    Community Support Team _Charlotte

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

Protocoder's avatar
Protocoder
New Member
4 years ago

Hello v-zhangti 

I really appreciate your time and help. I have this solution in the search was specifically looking in M language, some guidelines suggest to use M language as the people receiving it are comfortable with M rather than DAX. 

anyways there are some exceptions too. If getting this in M is not possible I will accept DAX,

I made the following changes more in line of what output I needed. 

 

Look1 = IF (
            LOOKUPVALUE(Table1[Column],Table1[Column],Table2[Column1]) <> BLANK (),
            BLANK (), 
            "No Matching"
            )

Is that ok? Results seems ok.