Forum Discussion
kp_wood13
Helper I
Helper IIf Exists in DAX or Power Query
What is the cleanest way to check if a value exists within a column? For instance in plain language I'm trying to do this:
IF overall_health >= 60 & 'project'[project_ID] EXISTS IN 'issues'[PK_ID]
THEN "Y"
ELSE "N"
kp_wood13 In DAX it would be the IN operator. You can use that along with SELECTCOLUMNS function.
1 Reply
- Greg_Deckler
Community Champion
kp_wood13 In DAX it would be the IN operator. You can use that along with SELECTCOLUMNS function.