Count of Records between dates month per month

[MarcosGalvani]

Hi,

I have a table like this:

Client	Type	StartDate	EndDate
1	F	01/01/2019	19/10/2022
2	P	01/01/2019	19/10/2022
3	F	01/01/2019	12/12/2019

I need to total of clients per month between the Min(StartDate) and the Max(EndDate) in a table like this:

Year	Month	Count
2019	January	3
2019	February	3
2019	March	3
......
2019	December	3
2020	January	2
...
2022	October	2

I would appreciate any help you can give me.

[MarcosGalvani]

Genius! Thanks!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Count clients measure: =
COUNTROWS (
    FILTER (
        Data,
        Data[StartDate] <= MAX ( 'Calendar'[Date] )
            && Data[EndDate] >= MIN ( 'Calendar'[Date] )
    )
)