Forum Discussion
Solved
How to use Task Outline Numbers from MS Project to group together task in Power BI
I have a MS Project with Site, Lot#, and Task Name. Each task has a start Finish Date and % complete. The Task Outline Number corresponds by site, Lot# and Task. For example: Site Lot# Task Nam...
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.
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.
Hi Steve, thank you very much for your reply and your attached file. I have a few questions (almost there!). Here is your example with my data.
Measure3 =
Var _sel = SELECTEDVALUE('Tasks'[TaskOutlineNumber])
Var _NR = LEFT(_sel,3)// Creating a "grouping" based off of the first three digits of the TaskOutlineNumber - correct?
RETURN
CALCULATE(MIN('Tasks'[TaskFinishDate].[Day]), FILTER(ALLSELECTED('Tasks'),[TaskName]="TO Release" && LEFT([TaskOutlineNumber],3) = _NR))//What is the FILTER doing here? Looking for any task with a Task Name that contains "TO Release" and is within the grouping? If I understood it better I might be able to make this work. Thanks so much!