cancel
Showing results for
Did you mean:
New Member

## Identify Re-Attenders Within A Set Period of Time

Hi All

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 Public Active Date/Time 1 01/10/2022 08:00 2 01/10/2022 08:30 3 03/10/2022 09:00 4 06/10/2022 09:30 3 04/10/2022 09:30 5 05/10/2022 09:30 2 07/10/2022 09:30 1 04/10/2022 09:30

Alex Spencer

1 ACCEPTED SOLUTION
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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a 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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!