Forum Discussion
How to use Task Outline Numbers from MS Project to group together task in Power BI
Like this?
Measure2 = VAR _sel = SELECTEDVALUE('Table'[Task Outline Number]) VAR _NR = LEFT(_sel,3) RETURN CALCULATE(MIN('Table'[Finish Date].[Date]), FILTER(ALLSELECTED('Table'), [Task Name ] = "Release" && LEFT([Task Outline Number],3) = _NR))File is attached.
Kind regards, Steve.
Then this should be it?
Measure2 = VAR _sel = SELECTEDVALUE('Table'[Task Outline Number]) VAR _NR = LEFT(_sel,3) RETURN CALCULATE(MIN('Table'[Finish Date].[Date]), FILTER(ALLSELECTED('Table'), CONTAINSSTRING([Task Name ],"Release") && LEFT([Task Outline Number],3) = _NR))File is attached.
Kind regards, Steve.
Update on the table information given above.
The task ID is unique to each summary and there are Task Outline levels associated with each task (ie Task Outline Level - Parent summary task = Level 3 and child summary task (Initiate) = Level 4 . The report = Level 5)
Example for Chicago I want to link the Release Report (Level 5) Date to the Initiate Date on Level 4 :
Chicago. - The Parent Summary Task (Level 3) Task Outline Number = 1.1.1
Chicago - Initiate. Child Summary Task (Level 4) = 1.1.1.2
Chicago - Report. (Level 5) Task Outline Number 1.1.1.2.4
Would I first form a Group of all the task under 1.1.1.X (write a DAX that says group first four digits). Extract the Finish Date associated with Initiate and then add +30edays to that date to calculate the Finish date the Report should be completed? Thoughts
So I wrote this out -
I took the Chicago - Report and I wrote a simple Dax expression that pulls out the ParentTaskName (in the example above the ParentTask Name is Chicago-Initiate. I called this Measure1. (FYI - The ParentTaskName is a column that exist on the table). Simple!