Forum Discussion

sv11's avatar
sv11
Helper I
7 years ago
Solved

Calculated column/Dax

Hi,

 

I have 2 columns (ID1 and ID2). I am required to create another column which displays "Yes" - if ID2 value is present in ID1 column and "No" - if not present, for every record.

 

Any help would be appreciated!

Thanks

Need Help

3 Replies

  • DouweMeer's avatar
    DouweMeer
    Impactful Individual
    7 years ago

    Create a custom table with distinct on ID2. Then you can continue using calculate + filter. 

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    7 years ago

    sv11 -

     

    Does this work for your needs?

    Column = IF(Table1[ID1]=Table1[ID2],"yes","no")