topic Re: How to count active items by month in DAX Commands and Tips

How to count active items by month

trevor-adare — Wed, 14 Apr 2021 10:10:14 GMT

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

Re: How to count active items by month

amitchandak — Wed, 14 Apr 2021 13:31:28 GMT

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-trend/ba-p/882970

Re: How to count active items by month

Anonymous — Wed, 14 Apr 2021 21:16:51 GMT

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...