Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
Hi Every body,
I have the following table :
Now please add columns to get the following:
Solved! Go to 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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |