Best way to separate data in one Column

Hi JayTG123 ,

You could create a new table by using DAX to split string by delimiter.

new_table = 
VAR tmp =
    ADDCOLUMNS (
        GENERATE (
            'table',
            VAR TokenCount =
                PATHLENGTH ( SUBSTITUTE ('table'[works location], ",", "|" ) )
            RETURN
                GENERATESERIES ( 1, TokenCount )
        ),
        "Split", PATHITEM ( SUBSTITUTE ( 'table'[works location], ",", "|" ), [Value] )
    )
RETURN
  SELECTCOLUMNS(tmp, "works location", [Split], "sales", 'table'[sales])

Best Regards,

Jay