How to count active items by month

[trevor-adare]

I have a requirement to show how many active items there were by month. The issue I have is counting the item in the intermediary months.

In the table there is a created date, completed date and open/closed status

 So for example, if an item was created date was in March 2020 and completed date was in June 2020, Then the item would need to add to the month counts as follows

March   April  May  June

1            1       1       0

Hope this all makes sense

[Anonymous]

@trevor-adare 

Please search this forum for similar (or even same) problems. There are plenty of them. This is such a popular horse that it's been beaten to death on these pages...

[amitchandak]

@trevor-adare , refer to this blog , very similar

Check for Current employee

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