Forum Discussion

StoryofData's avatar
StoryofData
Helper III
3 years ago
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...
Need Help
Tutorial Requests
  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    3 years ago

    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] )
    )

marcelsmaglhaes's avatar
marcelsmaglhaes
Super User
3 years ago

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] )
)