Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If and Contains

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" the...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    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

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago

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