Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count of Active Users In date range

Hi I have a dataset like below  User       Created Date      Last Date Ami        01-06-2020        17-06-2020 Asi          03-07-2020        28-07-2020 Neel        06-07-2020       22-07-20...
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Anonymous 

    take a look at the following solution:

     

     

    Count active User = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Created Date] <= MIN('Calendar'[Date]) && 'Table'[Last Date] >= MIN('Calendar'[Date])
    )
)

     

    Regards from the town where the legend of the Pied Piper of Hamelin is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi Anonymous 

take a look at the following solution:

 

 

Count active User = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Created Date] <= MIN('Calendar'[Date]) && 'Table'[Last Date] >= MIN('Calendar'[Date])
    )
)

 

Regards from the town where the legend of the Pied Piper of Hamelin is at home
FrankAT (Proud to be a Datanaut)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you

It is working