Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Experts, I need your help again, I have this table called Grade with all the details, and I want to create a new column called Grade Final with general details, by referring to the previous column.
How can I do this in DAX, essentially I want to generalize the Grade number in the Grade Final column
Grade | Grade Final |
Senior Manager (3.3) | Grade 3 |
Manager (3.1 - 3.2) | Grade 3 |
Senior Associate (2.1) | Grade 2 |
Director (4) | Grade 4 |
Program Manager (2.3) | Grade 2 |
Deputy Program Manager (2.1) | Grade 2 |
Solved! Go to Solution.
Hi @kangkopi15
Your example data is different to your actual data in that the actual data has some grades that do not contain ().
try this instead
Grade Final =
VAR _Bracket = SEARCH("(", [Grade], ,0)
RETURN
IF (_Bracket > 0 , "Grade " & MID([Grade], _Bracket +1,1), "Grade " & MID([Grade], LEN([Grade]),1))
regards
Phil
Proud to be a Super User!
Hi @kangkopi15
Your example data is different to your actual data in that the actual data has some grades that do not contain ().
try this instead
Grade Final =
VAR _Bracket = SEARCH("(", [Grade], ,0)
RETURN
IF (_Bracket > 0 , "Grade " & MID([Grade], _Bracket +1,1), "Grade " & MID([Grade], LEN([Grade]),1))
regards
Phil
Proud to be a Super User!
Hi @kangkopi15
Create the new column with this
Grade Final = "Grade " & MID([Grade], FIND("(", [Grade])+1,1)
Regards
Phil
Proud to be a Super User!
Hi @PhilipTreacy I tried to use the formula in the actual table, but unfortunately it doesn't work
I suppose to have Band 3, Band 3, Band 2 and so on under Band column
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |