Contains function

[Anonymous]

Hello Community  -  I am trying to get a result that shows me the results of the IF statement below.  

My challenge is that I need to discern between "PJOB" and "JOB".    Ideally I would use a SWITCH statment I think, but my immediate question is how do I get the formula to differentiate between "PJOB"  and   "JOB"?    Using the Containsstring function grabs both, which is not what I want.   Any help is appreciated!

JOB or PO = IF(CONTAINSSTRING(SLPlanningDetail_Query[MrpRef],"JOB"),"JOB",IF(CONTAINSSTRING(SLPlanningDetail_Query[MrpRef],"PO"),"PO",""))

Using my Excel data example below, this is what I would want the corresponding output from the calculated column to be: 

JOB

PO

PJOB

[parry2k · Accepted solution]

@Anonymous change to this:

JOB or PO = 
SWITCH ( TRUE(),
CONTAINSSTRING(SLPlanningDetail_Query[MrpRef],"PJOB", "",
CONTAINSSTRING(SLPlanningDetail_Query[MrpRef],"JOB"),"JOB",
CONTAINSSTRING(SLPlanningDetail_Query[MrpRef],"PO"),"PO",
"")

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Anonymous]

Thanks @parry2k   I had thought that the containsstring function would capture anything with the string "job" so that it would end up capturing both  (and therefore return blank if it found the string "JOB").