Forum Discussion
Helper INew simplify new column from another column
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 |
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
4 Replies
- PhilipTreacy
Super User
Hi kangkopi15
Create the new column with this
Grade Final = "Grade " & MID([Grade], FIND("(", [Grade])+1,1)Regards
Phil
kangkopi15Hi 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
- PhilipTreacy
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
- kangkopi15
This is working, thank you PhilipTreacy