Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
koorosh
Post Partisan
Post Partisan

path file parent child

Hi Every body,

 

I have the following table :

koorosh_0-1723307322932.png

Now please add columns to get the following:

koorosh_1-1723307382519.png

 



 

1 ACCEPTED SOLUTION
AnkitaaMishra
Super User
Super User

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 :

AnkitaaMishra_0-1723312597452.png

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

AnkitaaMishra_1-1723312653468.png

AnkitaaMishra_1-1723313126792.png

 

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

AnkitaaMishra_2-1723312772867.png

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

AnkitaaMishra_2-1723313176202.png

 

AnkitaaMishra_0-1723313081095.png

 


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



View solution in original post

2 REPLIES 2
k1eyvanYYZ
Regular Visitor

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
Super User
Super User

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 :

AnkitaaMishra_0-1723312597452.png

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

AnkitaaMishra_1-1723312653468.png

AnkitaaMishra_1-1723313126792.png

 

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

AnkitaaMishra_2-1723312772867.png

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

AnkitaaMishra_2-1723313176202.png

 

AnkitaaMishra_0-1723313081095.png

 


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



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.