Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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
5 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)

rwegmann's avatar
rwegmann
Frequent Visitor
5 years ago

FrankAT Hi Frank, I've tried this for my issue which is similar, but doesn't appear to be working.   What is the relationship between the two tables, 'Calendar' and 'Table'?  It is simply 'Calendar'[Date] to 'Table'[Created Date}?  If so, that is analogous to what I have.   Thanks in advance.