If and Contains

[Anonymous]

Hello,

I am new to Power BI and I need help creating an additional column using an IF and Contains Statement.

I am looking for an IF statement similar to = IF (Table, Name, contains "DEV" then "BOL" other wise "Other".

[az38]

@Anonymous 

try column

Column = IF(SEARCH("DEV", Table[Name]) > 0, "BOL", "Other")

@vivran22 LEFT() function will be actual only for values which starts from BOL

[vivran22 · Accepted solution]

@Anonymous 

Try this:

Column = IF(LEFT('Table'[Name],3) = "DEV","BOL","OTHER")

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn