Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AlexSpencer
New Member

Identify Re-Attenders Within A Set Period of Time

Hi All

 

Please can you help?

 

We are looking to identify when somebody re-usses our service within a set period of time (24 hours/48 hours etc.). Each person has a unique identifier and an active date/time. For example from the below it would identify that Member of Public #3 re-used the service within 48 hours, whereas nobody else did in the below table: 

 

Member of PublicActive Date/Time
101/10/2022 08:00
201/10/2022 08:30
303/10/2022 09:00
406/10/2022 09:30
304/10/2022 09:30
505/10/2022 09:30
207/10/2022 09:30
104/10/2022 09:30

 

Thank you in advance for all your help.

 

Alex Spencer

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AlexSpencer , one is you can diff in hours with next date

 

new column =

var _min = minx(filter(Table, [Member of Public] = earlier([Member of Public]) && [Active Date/Time] > earlier([Active Date/Time])),[Active Date/Time])

return

datediff([Active Date/Time], _min, hour)

 

You can use this column to 24/48 hour repeat

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@AlexSpencer , one is you can diff in hours with next date

 

new column =

var _min = minx(filter(Table, [Member of Public] = earlier([Member of Public]) && [Active Date/Time] > earlier([Active Date/Time])),[Active Date/Time])

return

datediff([Active Date/Time], _min, hour)

 

You can use this column to 24/48 hour repeat

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.