IF Contain function value

[Sandie_Fong]

I need to create a new column called "Job Group" based on the "EE List.Job" list. 

If the cell contain HSS, RN, Clinician from the EE List.Job, then the new column of the corresponding row shows "HSS", "RN", "Clinician".

Thanks in advance! 

[Omid_Motamedise]

You c an use

if Text.ContainsAny([EE List.Job], {"casee 1","casee 2","casee 3","casee 4"}) then ................. else ...........

[AlienSx]

Table.AddColumn(Source, "Job Group", each List.Intersect({Text.Split([EE List.Job], " "), {"HSS", "RN", "Clinician"}}){0}?)

[shafiz_p · Accepted solution]

Hi @Sandie_Fong  Try below code in power query advance option:

= Table.AddColumn(#"PreviousStepName", "Job Group", each if Text.Contains([EE List.Job], "HSS") then "HSS" else if Text.Contains([EE List.Job], "RN") then "RN" else if Text.Contains([EE List.Job], "Clinician") then "Clinician" else null)

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Sandie_Fong]

Thank you! I was trying to write this myself but have error with expression. Yours worked.