IF and with a contains criteria

[Shadd307]

I have a table that has numerous columns but I an trying to create a new column called work group where the issue type = "Initiative" and labels contains "Bank Name" and if both true "Bank Name" else "Not Bank Name"

Issue Type	Labels	Work Group (new Column)
Initiative	[Bank; Q4; Data team]	Bank
Story	[Bank; Q1; Docs]	Not Bank
Initiative	[Market; Q4; Policy]	Not Bank
Etc...

[Comex_Palmali]

You can try something like this:

WorkGroup = IF(AND(Planilha1[Issue Type]="Initiative",LEFT(Planilha1[Labels], FIND(";",Planilha1[Labels])-1)="[Bank"),"Bank","Not bank")

With this I have achieved the same result that you want.

[hokeson]

it looks like you need to create conditional column.

#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "WorkGroup", each if Text.Contains([Issue Type], "Initiative") and Text.Contains([Labels], "Bank") then "Bank" else "Not Bank")

[truptis]

@Shadd307 ,

Try this:

Result = IF([issuetype] = "initiative", IF( containstring(tablename, [label], "bank name", "Bank", "Not Bank"), "not bank"))

@Shadd307 -> if this helps you then please hit the thumbs up and mark it as a solution. Thanks.