Forum Discussion

SJ25's avatar
SJ25
Icon for Resolver I rankResolver I
5 years ago
Solved

Counting Projects started & finished each month

Hello All,

 

I'm trying to get a simple count of how many projects got started in each motnh and how many got completed. I have the start & end date for all projects, sample below:

Start DateEnd Date
2/12/20203/15/2020
3/10/20204/10/2020
5/12/20208/24/2020

 

Here's the output I'm looking for:

MonthsStartedCompleted

Jan

  
Feb1 
March11
April 1
May1 
June  

July

  
August 1

 

I've created an independent table with all months in it, but I think what's causing an issue for me is when I establish a relationship to my main table containing the dates. 

 

Any help would be much appreciated