Counting Projects started & finished each month

[SJ25]

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 Date	End Date
2/12/2020	3/15/2020
3/10/2020	4/10/2020
5/12/2020	8/24/2020

Here's the output I'm looking for:

Months	Started	Completed
Jan
Feb	1
March	1	1
April		1
May	1
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

[amitchandak · Accepted solution]

@SJ25 , refer if this blog on a similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or video :https://youtu.be/e6Y-l_JtCq4

[SJ25]

Thanks a ton! Worked great