Segregate the column

[Anonymous]

Hi,

I have a column Iteration Path in my dataset which i want to divide into Dev and Non-Dev.

Kindly let me know the easiest way to have another column with only Non-Dev values. Say I want a column which shows values from iteration Path columns containing only "Non-Dev".

Regards,

Himanshu

[amitchandak]

@Anonymous , Create a new column in DAX like

Switch(true(),

search("-Dev",[Column],,0) >0, "Dev",

search("-Non-Dev",[Column],,0) >0, "Non Dev",

"Other"

)

[Anonymous]

@amitchandak Not working properly.

I cant see Non-Dev in my column also Dev contains Non-Dev values as well.

[amitchandak · Accepted solution]

@Anonymous , There are two types of NonDev in the first screen shot in initial post

Try like

Switch(true(),

search("Non-Dev",[Column],,0) >0, "Non Dev",

search("NonDev",[Column],,0) >0, "Non Dev",

search("Dev",[Column],,0) >0, "Dev",

"Other"

)