Create a measure to count distinct for the last day, week and month.

[Anonymous]

Hello,

   I have a table called Event Log that tracks log ins by email address. I want to count the distinct email addresses [email] in this log for the last day, week, month, & quarter in [Timestamp]. I wanted to create a measure for each time period.

Email count last 24 hours = CALCULATE(DISTINCTCOUNT('Event Log'[Email]), 'Event Log'[Timestamp] in HOUR(NOW)-24)

Any ideas?

Cheers,

Peter

[amitchandak · Accepted solution]

@Anonymous , Try like

Email count last 24 hours = CALCULATE(DISTINCTCOUNT('Event Log'[Email]), 'Event Log'[Timestamp] >= now() -1 && 'Event Log'[Timestamp] <= now() )

or

Email count last 24 hours = CALCULATE(DISTINCTCOUNT('Event Log'[Email]), 'Event Log'[Timestamp] >= now() -time(23,59,59) && 'Event Log'[Timestamp] <= now() )