extract values from comma separated values

Hey Anonymous ,

as requested here is a DAX solution.

Based on my sample data:

I created this calculated column, as DAX does not allow to overwrite existing values.

Name new = 
var _path = SUBSTITUTE('Table'[Name] , "," , "|" )
var _pathlength = PATHLENGTH(_path)
var _newstring = 
    CONCATENATEX(
        FILTER(
            ADDCOLUMNS(
                GENERATESERIES(1 , _pathlength)
                , "_name" , PATHITEM(_path, ''[Value])
            )
            , LEFT([_name], 3) = "App"
        )
        , [_name]
        , ","
    )
return
_newstring 

The following screenshot shows the table with the new column: