New column sorted alphabetically

[Vendelin]

I have column A, with many letters separated by a comma. I want a new column B, where i sort column A alphabetically.

See example Fig 1

Fig 1

Column A	Column B
A,B,C	A,B,C
B,C,A	A,B,C
A,C,B	A,B,C
B,A,C	A,B,C
B,C,D	B,C,D
D,A,C	A,C,D
C,E,A	A,C,E

Can anyone help me with a code for this? 

[Vendelin]

Thanks tamerj1 it work perfekt 🙂

[tamerj1 · Accepted solution]

Hi @Vendelin 

please try 

ColumnB =
VAR String = 'Table'[ColumnA]
VAR Items =
    SUBSTITUTE ( String, ",", "|" )
VAR Length =
    COALESCE ( PATHLENGTH ( Items ), 1 )
VAR T1 =
    GENERATESERIES ( 1, Length, 1 )
VAR T2 =
    SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
RETURN
    CONCATENATEX ( T2, [@Item], ",", [@Item], ASC )