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.
HI Steve.
Currently in the Return we have a FILTER on the taskName so that it returns only those Task with the Name that equals (exactly) the word release. However, the task name(s) actually "contains" the word "release".
So it would look something like this (but I cannot get the CONTAIN function to work). Does this help explain it?
RETURN
CALCULATE (MIN('Table'[Finish Date].[Date]), CONTAINS(ALLSELECTED('Table'), [Task Name] "Release"
Thanks -
BTW I have been responding but not all my responses get posted. I really appreciate your help. I am so close!
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.
Thank you so much, this IS GREAT! I could not figure out how to add the CONTAINSSTRING.
MUCH APPRECIATED
Pedagogic368 wrote:
Thank you so much, this IS GREAT! I could not figure out how to add the CONTAINSSTRING.
MUCH APPRECIATED
Welcome, glad to be of help.