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 w...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    sv11 -

     

    Does this work for your needs?

    Column = IF(Table1[ID1]=Table1[ID2],"yes","no")
ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

sv11 -

 

Does this work for your needs?

Column = IF(Table1[ID1]=Table1[ID2],"yes","no")
  • DouweMeer's avatar
    DouweMeer
    Impactful Individual
    7 years ago

    ChrisMendoza , he mentioned column ID1, not value ID1.