Forum Discussion
JakeMenday
6 years agoNew Member
Custom filter and create groups
Hi, I have a large data file containing tasks of work, either complete or ongoing. Each of these tasks has a Job description and I want to group the job description into 4 categories; Civil, Elec...
v-diye-msft
6 years agoCommunity Support
Hi JakeMenday
Not sure if my understanding is correct.
Did you try the conditional column in the power query? you can define the contains function, if there're some description should be included by others, the Contains works: