Get number of events within 60 minutes from each event

[MarcoBeca]

Hi everybody,

I need some help with a DAX.  

I have a table with following columns:

• Date time 
• Card Id
• Contract Id
• EventType

I need to produce a table showing the number of events within 60 minutes from each event with eventtype = 3, grouped by card id, contract id and eventtype. 

I can only use DAX - not possible to edit dataset.

Your help will be much appreciated!

[v-jayw-msft]

Hi @MarcoBeca ,

What time do you want to compare Date time with?

You may consider to create a measure like below:

new_table = summarize(filter(table,eventtype=3&&datediff(date time,time2,MINUTE)<=60),card id, contract id,"count",countrows(table))

Best Regards,

Jay

[MarcoBeca]

Hi Jay,

I'll be testing out your solution and I will let you know in the next days. thank you for your support!

Marco