Count Rows with Date Condition

[areias_br]

Hi,

I have a table called "Actions" and another table called "tb_Calendar" which is a calendar table. 

Action Name | Created Date | Closed Date | Status (Open or Closed)

I need a view were I can see the amount of actions that were opened during a period. 

It should show that in January I had 40 actions opened, February 30, etc...THis is based on the Created Date and Closed Date collums. 

The problem is that i'm only getting the number of actions that were opened during that period and not the amount of all actions that were opened during that period.

[Ashish_Mathur · Accepted solution]

Hi,

I just responded to a similar post here.  Please see the link which i have shared there.

[Ashish_Mathur · Accepted solution]

Hi,

I just responded to a similar post here.  Please see the link which i have shared there.

[areias_br · Accepted solution]

It was not the perfect solution, but helpmed to have a insight on how to solve the question.

I created a table based on this tutorial with all the Weeks from my calendar table.
https://gorilla.bi/power-query/date-table-with-monthly-increments/

Them I used Added a Collum:
Opened Actions =
COUNTROWS(
FILTER(
'AllActions',
'AllActions[Created Date] < 'tb_Followup '[Date] && ('AllActions[Closed Date] > 'tbFollowup'[Date] || 'AllActions[Closed Date] = BLANK())
))

[ExcelMonke]

You can consider the following:

Measure = 
CALCULATE (DISTINCTCOUNT(Actions[Action Name]), ALLEXCEPT(tb_Calendar[Month]),FILTER(Actions,Actions[Status]="Open"))

[areias_br]

Hi,

Thanks for the reply, but I believe it doesn't work.

The Status "Open" changes over time. So...In January an action might have been as "Open" and now It can show as "Closed".

I need to compare the dates.