How to make use of DAX to create 2 new fields from "GL Description" field

[admin11]

Hi All

How to make use of DAX to create 2 new fields from "GL Description" field 

For Example :-

AM ACCOUNTANCY FEE

i Hope to convert to :-

GL_Desc2=AM

GL_Desc_Oth=ACCOUNTANCY FEE

My PBI file :-

https://www.dropbox.com/s/ds3bbmxa3dogvvc/PBS_VER050%20GL_LE.pbix?dl=0

Paul

[Fowmy · Accepted solution]

@admin11 

Add the following two columns, replace the name of your table and column name with yours in the formula:

GL_Desc2 = LEFT(Table[Column],2)

GL_Desc_Oth = TRIM(MID(Table[Column],3,255))

[admin11]

@Fowmy 

Thank you very much it work.

Paul