Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative Unfinished Projects

Hi, I need both a bar graph and the underlying details (in a table) to show projects when they started until they finish, carrying over unfinished projects into the next quarter.   Basically the d...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Now we are moving into "shouldn't that rather be a calculated column?"  territory.  Are any of the statuses influenced by user interaction with the report?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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. 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.