Forum Discussion
Count events between two dates
Hey there I'm facing a situation where I must calculate how many occurrences (from the Fact table) took place between two dates (that also comes from my Fact table). This is my fact ...
This piece of code solved my problem:
COUNTROWS(FILTER(ALL(Data), MAX('Calendar'[Date]) > [EventStart] && MAX('Calendar'[Date]) < [EventEnd]))
Hi, is it possible in this example to count, how many and what ID's was active in each month ? To get table like this:
| Month-Year | ID's | Active ID's |
| Jan-2021 | 32967 | 2 |
| Jan-2021 | 64315 | 1 |
| Feb-2021 | 32967 | 4 |
| Mar-2021 | 40415 | 9 |