Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Joachim2108
Helper I
Helper I

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
Helper I
Helper I

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
Helper I
Helper I

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"

AntrikshSharma
Community Champion
Community Champion

@Joachim2108 Wildcards are not supported in DAX afaik, you will have to use either

 

https://dax.guide/containsstring/

or 

https://dax.guide/containsstringexact/

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors