Forum Discussion
Cumulative Unfinished Projects
I would provide the user the ability to filter on Project or Quarter using slicers.
I originally tried to do it using calculated columns but figured there might be a better solution for a large (and growing data set).
I couldn't simultaneously find the max per project per quarter and get the unfinished projects to continue until done.
the way I read your questions/intentions seems to require a materialization of project status per quarter - which is easiest done either in Power Query or as a calculated table in DAX. Let's say you wanted to give the user the option to select specific date ranges - that would have an impact on the "max" status in a quarter. But if they always only can select quarters to look at then the materialization would be sufficient.