Number of projects per month

[Anonymous]

Hi people,

I'm dealing with some thoubles in create a Dashboard to my projects departament.

The data is:

Project ID	Start date	Final Date
1	01/01/2019	25/06/2019
2	16/02/2019	14/09/2019
3	05/06/2020	30/06/2020

I have to create a table that it shows how many projects by month the department is conducting. Using the case above, the results would be:

Month / Year	Count
01/2019	1
02/2019	2
03/2019	2
04/2019	2
05/2019	2
06/2019	3
07/2019	1

I've tried to use this formula, but this not work for me:

Calendário = ADDCOLUMNS(CALENDAR(DATE(2019;1;1);DATE(YEAR(TODAY());MONTH(TODAY());day(TODAY())));

"Dia da semana";WEEKDAY([Date];1);

"Workday";SWITCH(WEEKDAY([Date];1);1;"Não";7;"Não";"Sim");

"Feriado";LOOKUPVALUE(Feriados[Feriado];Feriados[Data];[Date]);

"Projetos conduzidos";CALCULATE(COUNT('Projetos - Jira'[Chave]);

FILTER('Projects';(EOMONTH('Projects'[Start date];-1)+1) <= [Date]);

FILTER('Projects';'Projects'[Final Date] >= [Date]);

))

Someone know how to solve this problem?

Thank you!

[Greg_Deckler]

Open Tickets was designed to solve this kind of issue:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

[Anonymous]

Hi @Greg_Deckler 

I didn't know this kind of proposal. Great! I'm goona try that and pray to solve my problem.

Thank you very much for your help! 🙂

[amitchandak · Accepted solution]

I have blog on similar lines :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Appreciate your Kudos.

[Anonymous]

Hi @amitchandak 

After I used your example, I could do it as I show below!

[Anonymous]

Hi @amitchandak . I think your case will solve my problem. I'm going to try this today at night and I give you a feedback about this solition.

Thank you so much for your help 🙂