Forum Discussion
Solved
Mark Project as Complete with Completion Date Using Activity Status and Completion Date
Hello, I cannot figure out how to create these two columns I need: "Project Status" to mark Projects as complete if all if it's activities are complete "Project Completion Date" to use the most r...
mhanne , Try new columns like
project Status =
var _1 = countx(filter(Table, [Project_id] = earlier([Project_id]) && [Activity Status] = "Active"),[Activity ID])return
if(isblank(_1) , "Complete", "Active")project Date =
countx(filter(Table, [Project_id] = earlier([Project_id]) && [project Status] = "Complete"),[Date])
Thank you SO MUCH! The first column worked perfectly, but I am having some issues with the second.
With my fields, it looks like this:
ProjectCompleteDate = countx(filter('Live Feed', [projectid] = earlier([projectid]) && [ProjectStatus] = "Complete"),[reviewcompleteddate])
When I put it in, it prompted me to add .[DATE] after the [reviewcompleteddate], but did not change the outcome. It would not let me enter just [DATE] by itself.
The issue is the the column is returning a count of the number of actvities in each project rather than the most recent review completed date. Am I doing something wrong?
Again, thank you so much for your help this is really saving me!
Again, thank you so much for your help this is really saving me!
For the Project Date measure, use MAXX instead of countx:
project Date =
MAXX(filter(Table, [Project_id] = earlier([Project_id]) && [project Status] = "Complete"),[Date])