Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 OR State Contains Not Applicable OR Not Disclosed then also blank
If all columns are filled in, concatenate Case # & Employee ID
Solved! Go to Solution.
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] )
)
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Thank you so so much! I went down few different avenues but did not try swith
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] )
)
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |