Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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 |
Thank you in advance for all your help.
Alex Spencer
Solved! Go to Solution.
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |