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.
PS
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;
where WBStbl is the table with the Work Breakdown Structure imported into Power BI model and the “.” i convert in “|” to estabblish the parent-child relationship
Sorry, I had a look at the shared file, that may be i am not fully understand.
I would need to apply and get as many columns as the levels defined.
I attached the excel file tab “Values” with example for the first few rows.
I also attached the Power Bi file with the table imported and modified with the WBS table imported and the parent child relationship defined “RawData” table
forgot to say that would need to sort in DAX rather than M language / Power Query.
as i do have multiple entrance for each schedule update.
Been the planners not diligent and continuosly modify the attributes (in this case the WBS) i do need to have for each entry
Hi
shoudl look like from the tab “Values” of the attached Excel file. I manually done for the first few rows.
After have split the levels from “WBS Code” for the level description need to pick from the “WBS Name”
is then a two step exercise, first divide the level parent-child and the pick the level description.
One last question, as this would need to be used accross multiple projects.
Some have up to 5 levels, other even more than 10, is there an way to make the levelling dynamic or need to put a hard constrain on the level that can be extracted with the hard coding for example up to 10.
Yes it is very informative and the idea of having an alert if projects have more than a pre-establoshed number of level it sound good.
so far we have not been lucky enough to enforce a common structure ccross the porjects.
but we are working on it, it is an issue of stakeholder management and Client.
We are also working on have a set of attroute costant accross the organization, but it is a long journey, however it is needed in order to been able to identify area of the Works that are not performing as needed and find solutions.
Hi @LucaB72, did the responses provided help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!
