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".
Go to Solution.
Column = IF(LEFT('Table'[Name],3) = "DEV","BOL","OTHER")
Cheers!VivekIf it helps, please mark it as a solutionKudos would be a cherry on the top 🙂https://www.vivran.in/Connect on LinkedIn
View solution in original post
Column = IF(SEARCH("DEV", Table[Name]) > 0, "BOL", "Other")
@vivran22 LEFT() function will be actual only for values which starts from BOL
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.