Following “AntrikshSharma” solution to “michellepace” query “Split by delimiter in dax: value 1 - value 2 - value 3”, I would like to take the opportunity to ask for your help.
I have similar problem to “michellepace”, but I do not know priory the number of level I do need to break down the text.
Attached the file excel of a template, showing a project Work Breakdown Structure, that should be split by parent-child relationship on the “WBS Code” field, so I can later on use as pivoting items in my Power Bi analysis of the project schedule.
To add a further complexity to the problem, the codes from the “WBS Code” structure has a hard coded structure, the meaning of the last child level, each row does represent, is stored in the “WBS Name” field.
Your support would be highly appreciated.
- Not all parent/child relationship for the various items have homogeneous level, but all converge to the project (level 0);
- In the attached file, the “LEVEL” field I added, is not coming as part of the standard report, so may be would be better to use as parameter if needed;
LucaProject WBS Structure.xlsx (233.7 KB)