Reply
Regular Visitor
Posts: 42
Registered: ‎08-07-2017
Accepted Solution

SQL CASE Statement to column using DAX

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? 

 

 

 


Accepted Solutions
Highlighted
Member
Posts: 93
Registered: ‎12-14-2016

Re: SQL CASE Statement to column using DAX

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"

)

View solution in original post


All Replies
Established Member
Posts: 177
Registered: ‎04-27-2018

Re: SQL CASE Statement to column using DAX

@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

Highlighted
Member
Posts: 93
Registered: ‎12-14-2016

Re: SQL CASE Statement to column using DAX

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"

)