Calculated column with comma delimited text split into columns in a new table

Hi Malsha 
If I understood you correctly and you need to split the column with Dax, please refer to the linked video:
https://www.youtube.com/watch?v=j0A6CYg-BfA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi Malsha 

You can refer to the following calculated table

Table 2 =
VAR a =
    ADDCOLUMNS ( 'Table', "path", SUBSTITUTE ( [Supervisors], ",", "|" ) )
RETURN
    SUMMARIZE (
        ADDCOLUMNS (
            a,
            "Supervisor1", PATHITEM ( [path], 1 ),
            "Supervisor2", PATHITEM ( [path], 2 ),
            "Supervisor3", PATHITEM ( [path], 3 )
        ),
        [Employee_ID],
        [Supervisor1],
        [Supervisor2],
        [Supervisor3]
    )

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.