SQL CASE Statement to column using DAX

[lukaspowerbi]

I have a sql case statement that I would like to translate into DAX. 

CASE WHEN mem_type LIKE '%full%' AND mem_council = 'Council' THEN 'Full on Council' 

         WHEN mem_type LIKE '%full%'  THEN 'Full' 

         WHEN mem_type LIKE '%Under%'  THEN 'Under 35' 

         END as 'Mem_Group'

Is that possible? 

[Anonymous · Accepted solution]

SWITCH(
 TRUE()
, AND( SEARCH ( "Full", mem_type, 1, 0 ) > 0, mem_council = "Council" ), "Full on Council"

, SEARCH ( "Full", mem_type, 1, 0 ) > 0, "Full"

, SEARCH ( "Under", mem_type, 1, 0 ) > 0, "Under 35"

, "Mem_Group"

)

[Anonymous]

@lukaspowerbi

The SWITCH function is very similar to a SQL CASE statement. Check out the documentation here:

https://msdn.microsoft.com/en-us/query-bi/dax/switch-function-dax

The syntax will be something like:

Column =
SWITCH(
   TRUE(),
   Case1,Value1,
   Case2,Value2,
   [Optional Default Value if no conditions are met]
)

Hope this helps,

Parker