Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Maybe there is a better way to do this but I am basically trying to create a column where if the employees title
The formula I am trying to use is:
Solved! Go to Solution.
hello @CiaraCaryl
your syntax looks good but here are some notes you probably want to put a note.
- in Line 4, NOT function is use for both containsstring but you need opposite value only for "Enterprise" for "AE".
- use comma in-between if statement
Here is one way to represent if statement based on your DAX.
Another way to write is using SWITCH.
Hope this will help you.
Thank you.
hello @CiaraCaryl
your syntax looks good but here are some notes you probably want to put a note.
- in Line 4, NOT function is use for both containsstring but you need opposite value only for "Enterprise" for "AE".
- use comma in-between if statement
Here is one way to represent if statement based on your DAX.
Another way to write is using SWITCH.
Hope this will help you.
Thank you.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |