New simplify new column from another column

[kangkopi15]

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

[PhilipTreacy · Accepted 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

[kangkopi15]

This is working, thank you @PhilipTreacy 

[PhilipTreacy]

Hi @kangkopi15 

Create the new column with this

Grade Final = "Grade " & MID([Grade], FIND("(", [Grade])+1,1)

Regards

Phil

[kangkopi15]

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