Forum Discussion
Solved
DAX with Multiple Conditions
How do I write out a measure that would concatenate two columns based on the following conditions: If Employee ID is blank then result should always be blank If Employee ID is filled in but City...
Hey StoryofData !
Try the DAX bellow, and if it helps, please mark as solved. Thanks!new_column =
SWITCH (
TRUE (),
[Employee_ID] = BLANK (), BLANK (),
[Employee_ID] <> BLANK ()
&& CONTAINS ( YOUR_TABLE, [CITY], "NOT APPLICABLE", [STATE], "NOT APPLICABLE" )
= TRUE ()
|| CONTAINS ( YOUR_TABLE, [CITY], "NOT DISCLOSED", [STATE], "NOT DISCLOSE" )
= TRUE (), BLANK (),
COMBINEVALUES ( "-", [CASE], [EMPLOYEE ID] )
)
Thank you so so much! I went down few different avenues but did not try swith