Forum Discussion
Solved
Create a "Project Completion Date" Column Based on Most Recent Activity Completion Date in Project
Good Morning! I am trying to create a "Project Completion Date" column to calculate the completion date for a completed project based off of the latest Activity Completion Date. Our syst...
mhanne The reverse date is due to condition with "Earlier". Fixed the DAX as following:
ProjectCompletionDate = CALCULATE(MAX(Sheet5[Activity Completion Date]),FILTER(Sheet5, Sheet5[Project Status]="Complete"&& Sheet5[Project ID]=EARLIER(Sheet5[Project ID])))Did I solve your problem?If yes, please give kudos and mark my reply Accepted!
Anonymous
Here is the formula when I use my own fields:
It is still giving me the same date in every row. When I turned off Auto date/time intelligence it gave me a number rather than a date and would not let me change the Data Type (when I tried the table wouldn't work until I removed the column).
I'm also a bit confused by your example, because the completion dates are switched in your table ( Project 1 should be 10/5/2020 and Project 2 should be 10/8/2020)
mhanne The reverse date is due to condition with "Earlier". Fixed the DAX as following:
ProjectCompletionDate = CALCULATE(MAX(Sheet5[Activity Completion Date]),
FILTER(Sheet5, Sheet5[Project Status]="Complete"
&& Sheet5[Project ID]=EARLIER(Sheet5[Project ID])))
Did I solve your problem?
If yes, please give kudos and mark my reply Accepted!