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.
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.