Forum Discussion

jsimmons25's avatar
jsimmons25
Frequent Visitor
6 years ago

Project for Web App Outline Numbers missing from data tables

It appears that the outline numbers are missing from the Project Task Table. Also was msdyn_wbsid is not avalible either. Is there a way to access these or recreate via some formula? Our project mana...
Need Help
Show and Tell
echolima201's avatar
echolima201
Frequent Visitor
3 years ago

Here is how I solved this issue for my purpose.  

 

I created a pach column: 

 

TaskPath = PATH('Project Tasks'[Task ID], 'Project Tasks'[msdyn_parenttask])
 
Then I created a new column for each level. 
 
Level 1  =
LOOKUPVALUE(
    'Project Tasks'[Task Name],
   'Project Tasks'[Task ID],
    PATHITEM('Project Tasks'[TaskPath], 1)
)
 
Level 2
 
LOOKUPVALUE(
    'Project Tasks'[Task Name],
   'Project Tasks'[Task ID],
    PATHITEM('Project Tasks'[TaskPath], 2)
)
 
And Finally created a hierarchy for each level.  Therefore I can find the parent task herarchy for each one of them.