New Colum based on text of other

[Anonymous]

Hi!

I´m working on a report but i got an issue.

I want to make a new column with stantard data name.

I have a colum like this

Name

Headseat 660

Mouse 660

Head 660

Headset-660

Headphone 660

Mou 660

I want to make a filter that looks for certain caracteristics, example:

I want it to look that starts with an H, has an S and ends in 660. For the Mouse that starts with M and ends in 660.

Name	Standard name
Headseat 660	Headset 660
Mouse 660	Mouse 660
Head 660	Headset 660
Headset-660	Headset 660
Headphone 660	Headphone 660
Mou 660	Mouse 660

I´ve tried conditional colums but it seems they are kind of limited.

[v-shex-msft · Accepted solution]

HI @Anonymous ,

You can check following link to know more about dax string comparison:

From SQL to DAX: String Comparison

Regards,

Xiaoxin Sheng