Forum Discussion

jimpatel's avatar
jimpatel
Post Patron
3 years ago
Solved

Vlookup

Hi, Thanks for looking at my post. I have 2 tables named as table 1 and table 2 and unfortunately i cant link those two tables because repeatation of part numbers. Issue is in table 1, i wanted to ...
  • jimpatel's avatar
    jimpatel
    3 years ago

    Thats fantastic. Thanks a lot for this formula. Much appreciated.

    What if instead of "if there are multiple different values in column 5 for the same part number, this will include them all in a comma separated list" , if any row have "YES" in column 5 then answer should be "YES". Is this something we can add in this DAX formula please? 

johnt75's avatar
johnt75
Super User
3 years ago

You could try

 

col 5 text =
VAR PartNumber = 'table 1'[part number]
RETURN
    CONCATENATEX (
        CALCULATETABLE (
            VALUES ( 'table 2'[column 5] ),
            TREATAS ( { PartNumber }, 'table 2'[part number] )
        ),
        'table 2'[column 5],
        ", "
    )

 

if there are multiple different values in column 5 for the same part number, this will include them all in a comma separated list

jimpatel's avatar
jimpatel
Post Patron
3 years ago

Thanks for your reply.  I am getting only , as the answer. Any idea please?