Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to assign a numeric value to various job titles. I can use the IF statement to make this work for two titles, but i have about a dozen various job titles that i need to assign a value to and havent been able to figure out how to accomplish this. Some of the titles will have the same value. For instance, i need PMs to have a value of 5, whereas Superintendents, Foreman and Field Engineers will have a value of 0. APMs will have a value of 2 and VPs will have a value of 75, etc.
Any and all help is greatly appreciated.
Solved! Go to Solution.
If the value is exactly defined by the title name, you need to use IF/SWITCH function to do it. such as write to: IF([Title]= "SUPERINTENDENT", "0", IF([Title]= "VICE PRESIDENT", "90"))..one by one. there's no easy way to do this. probably SWITCH function can be simpler than IF.
Not quite understand your requirement, could you please post some captures to clarify more details?
Thanks for responding. what i am looking to do is to assign a numeric value to various job titles so as to then use that value in another calculation. I can use the IF statement to say that
Title | Value |
Superintendent | 0 |
Project Manager | 5 |
Assistant Project Manager | 2 |
Project Manager Assistant | 90 |
Vice President | 75 |
Assistant Superintendent | 0 |
General Superintendent | 5 |
If the value is exactly defined by the title name, you need to use IF/SWITCH function to do it. such as write to: IF([Title]= "SUPERINTENDENT", "0", IF([Title]= "VICE PRESIDENT", "90"))..one by one. there's no easy way to do this. probably SWITCH function can be simpler than IF.
thanks for the input. I didnt know that i could keep using the IF statement for the number of times i needed within the same equation. It is working.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |