Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
83 | |
77 | |
71 | |
69 | |
53 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |