cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lukaspowerbi Regular Visitor
Regular Visitor

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? 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
yash1105 Member
Member

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

2 REPLIES 2
Highlighted
Anonymous
Not applicable

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

yash1105 Member
Member

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)