Forum Discussion
Solved
Looking up the Latest Value for a Given Task Name
Hello, I use Power BI to compile information from multiple projects entered into Microsoft Project (MSP). The project name is associated with a Projects table, and date-level information is associate...
This didn't quite work, but you set me on the right path! Here's what ended up working:
60% Turn In = CALCULATE ( MAX ( Tasks[FinishDate]), Tasks[taskname] = "Work on Design - 60%")
Thank you!
HI nck13441,
You can try to use calculate function and max function to get last date based on task name and projectid.
Calculate column formula:
LastDate =
CALCULATE (
MAX ( Task[Date] ),
FILTER (
ALL ( Task ),
[ProjectID] = EARLIER ( [ProjectID] )
&& [Task Name] = EARLIER ( [Task Name] )
)
)
Regards,
Xiaoxin Sheng
This didn't quite work, but you set me on the right path! Here's what ended up working:
60% Turn In = CALCULATE ( MAX ( Tasks[FinishDate]), Tasks[taskname] = "Work on Design - 60%")
Thank you!