cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joachim2108
Frequent Visitor

Using wildcard characters in a SWITCH function

Hi!

 

I'm struggling to create a new collumn with wildcard characters, based on certain values in another collumn using the SWITCH function.

 

The products in the original collumn are grouped between 100-900 (e.g. 112, 320 etc.). I want to group these into smaller categories.

 

In plain english I want for example: if the ProductGroup starts with 3, i.e. is between 300-399 (data type = text), it needs to be categorised as "Tools". I used wilcard characters in the DAX query, however it doesn't seem to recognise them. A piece of the query is below - what am I doing wrong? Thanks in advance!

 

 

ProductCategory=

SWITCH ( TRUE (),  

 

'Storage’[ProductGroup] = "3**", "Tools",

'Storage’[ProductGroup] = "4**", "Service",

'Storage’[ProductGroup] = "5**", "Transport",

    "Other" )

1 ACCEPTED SOLUTION
Joachim2108
Frequent Visitor

Hi all, the solution turned out to be:

 

IF (LEFT ( Storage[Productgroup) = LEN(1)) = "3", "Tools",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "4", "Service",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "5", "Transport"

View solution in original post

3 REPLIES 3
Joachim2108
Frequent Visitor

Hi all, the solution turned out to be:

 

IF (LEFT ( Storage[Productgroup) = LEN(1)) = "3", "Tools",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "4", "Service",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "5", "Transport"

View solution in original post

AntrikshSharma
Super User II
Super User II

If I can't use wildcards, could I combine the SWITCH statement with a LEFT statement?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors