Count of Active Users In date range

[Anonymous]

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-2020
Kamal     18-06-2020       16-07-2020
Soumya  14-07-2020       30-07-2020

I need the count of all active users in between a date range.
for ex- Neel was active in between 18th June to 1st July , so when i choose the date range in between 18th June & 1st July, Neel should be counted as one active User
Result should be something like this

Date                 Count of Active Users
01-06-2020              1
02-06-2020              1
..

..

08-07-2020              3

..
15-07-2020              4

Just curious to know Is this possible in Power bi???

Thanks
Amit

[FrankAT · Accepted solution]

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]

@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.

[Anonymous]

Thank you

It is working

[amitchandak]

@Anonymous ,

Refer the blog on a very similar topic

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Greg_Deckler]

@Anonymous  - This is Open Tickets - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147