Not statement within Conditional Column

[PhilSap]

Hey!

I have a campaign UTM that contains the what I need the same code which is PMAX and PLA.  I am trying to seperate these and below is an Example what I am aiming for 

PMAX= Campaign UTM Contains PMAX but NOT PLA

PLA= Campaign UTM contains PLA but NOT PMAX

I am trying a custom column with the below code but doesn't seem to be working

if Text.Contains([Campaign],"PMAX") <> Text.Contains([Campaign] ,"PLA") then "PMAX"
else "null"

Not sure where I am going wrong but any help is appreciated !

[PhilSap]

thanks @lbendlin that worked!

[v-pgoloju]

Hi @PhilSap,

Just following up to check if the solution shared by our Super User @lbendlin  helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!

If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.

Best regards,

Prasanna Kumar

[lbendlin · Accepted solution]

if Text.Contains([Campaign],"PMAX") and not Text.Contains([Campaign] ,"PLA") then  "PMAX"

else if not Text.Contains([Campaign],"PMAX") and Text.Contains([Campaign] ,"PLA") then  "PLA"

else "undefined"