Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Project count over time

Hi,    I would like to create a graph that shows active projects over time.  I look after a portfolio of approx 100 projects which all have start and finish dates. I'd like to show the volume projec...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Download the PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

😞 I tried the link on two different PCs. Not letting me through.

mh2587's avatar
mh2587
Super User
4 years ago

let me make another one

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Many thanks I got your google docs version.  Only one problem (might be the way I described it). What I need to see is the number of active projects each month, but from January 2018 till Dec 2024.

    Darrin

    Thanks agian for your patience.

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

    what will be the cretiria for active projects would explain it further 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    For any month M between Jan'18 and Dec '24, Active = Start Date <= M AND Finish Date >= M.