counting records before a specific date

Hi Anonymous ,

Here I create a sample to have a test.

DimDate table:

DimDate = 
ADDCOLUMNS( CALENDAR(DATE(2022,01,01),DATE(2022,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]),"MonthLongName",FORMAT([Date],"MMMM"))

Please try this code to create a measure to count the active user before each month ending date.

Measure:

Active User =
VAR _MAXDATE =
    MAX ( DimDate[Date] )
RETURN
    CALCULATE (
        COUNT ( RegisteredUsers[User Name] ),
        FILTER (
            RegisteredUsers,
            RegisteredUsers[Activated Date] <= _MAXDATE
                && OR (
                    RegisteredUsers[In-Activated Date] = BLANK (),
                    RegisteredUsers[In-Activated Date] > _MAXDATE
                )
        )
    )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.