Need help in removing succeeding commas in a cell.

[Anonymous]

Hello, I have below table and want to transform Column A to Column B with below output.

Basically, I want to remove all succeeding commas. I can do this in transform data however Column A is calculated in DAX and it's not present yet in transform data so I need a DAX to remove the succeeding commas.

[Khushidesai0109]

Hii @Anonymous 

Can you please provide the snapshot of the required output?

[bhanu_gautam · Accepted solution]

@Anonymous , Use the below DAX

Column B =
VAR SplitString = SUBSTITUTE([Column A], ",", "|")
VAR StringTable = ADDCOLUMNS(
GENERATESERIES(1, LEN(SplitString) - LEN(SUBSTITUTE(SplitString, "|", "")) + 1),
"Element", PATHITEM(SplitString, [Value], TEXT)
)
VAR FilteredTable = FILTER(StringTable, [Element] <> "")
RETURN CONCATENATEX(FilteredTable, [Element], ",")