Calculated column/Dax

[sv11]

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

[ChrisMendoza · Accepted solution]

@sv11 -

Does this work for your needs?

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

[DouweMeer]

@ChrisMendoza , he mentioned column ID1, not value ID1. 

[DouweMeer]

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