Forum Discussion
Segregate the column
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
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"
)
3 Replies
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"
)
amitchandak Not working properly.
I cant see Non-Dev in my column also Dev contains Non-Dev values as well.
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"
)