Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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".
Solved! Go to 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
@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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |