path file parent child

[koorosh]

Hi Every body,

I have the following table :

Now please add columns to get the following:

[k1eyvanYYZ]

I think the @AnkitaaMishra  solution will generate only one column.

This might be a better solution : 

Populate columns in Power BI based on the folder s... - Microsoft Fabric Community

[AnkitaaMishra · Accepted solution]

Hi @koorosh , yes you can achieve this using power query editor , follow below steps :

Step 1) Open the power query editor and duplicate the Path Column by right clicking on the column :

Step 2) Right click on the duplicated column and select split column by delimiter :

Step 3) Then you can remove the below highlighted column :

Step 4) now for the first splitted column, you can replace the blank value with 'root' as shown below :

This will give you the expected result.

let me know if this works for you else share the additional details for your requirement.

Thanks,

Ankita