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])
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])