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.
Hello Everyone
I need help to calculate duration of those events that occur in my data. In order to solve it, I have to be able to extract the start and end time from dataset.
So how can I achieve result as in the picture?
So how can I make a new tabel that contain all these "events", or make a new column where end time or start time of events is return as pictured below?
DATASAMPEL:
Server | Dato | Optaget () |
d2d3f | 06.01.2020 09:29 | 0 |
d2d3f | 06.01.2020 09:40 | 1 |
d2d3f | 06.01.2020 09:44 | 1 |
d2d3f | 06.01.2020 09:49 | 1 |
d2d3f | 06.01.2020 09:59 | 0 |
d2d3f | 06.01.2020 10:07 | 1 |
d2d3f | 06.01.2020 10:15 | 1 |
d2d3f | 06.01.2020 10:30 | 0 |
d2d3f | 06.01.2020 10:43 | 1 |
d2d3f | 06.01.2020 10:45 | 1 |
d2d3f | 06.01.2020 11:00 | 0 |
d2d3f | 06.01.2020 11:15 | 0 |
d2d3f | 06.01.2020 11:21 | 1 |
d2d3f | 06.01.2020 11:30 | 0 |
d2d3f | 06.01.2020 11:45 | 0 |
d2d3f | 06.01.2020 11:59 | 1 |
d2d3f | 06.01.2020 12:00 | 1 |
d2d3f | 06.01.2020 12:15 | 0 |
d2d3f | 06.01.2020 12:25 | 1 |
d2d3f | 06.01.2020 12:30 | 1 |
d2d3f | 06.01.2020 12:45 | 1 |
d2d3f | 06.01.2020 13:00 | 1 |
d2d3f | 06.01.2020 13:15 | 1 |
d2d3f | 06.01.2020 13:30 | 1 |
d2d3f | 06.01.2020 13:45 | 1 |
d2d3f | 06.01.2020 14:00 | 1 |
d2d3f | 06.01.2020 14:07 | 1 |
d2d3f | 06.01.2020 14:15 | 0 |
d2d3f | 06.01.2020 14:30 | 0 |
d2d3f | 06.01.2020 14:45 | 0 |
d2d3f | 06.01.2020 15:00 | 0 |
d2d3f | 06.01.2020 15:15 | 0 |
d2d3f | 06.01.2020 15:30 | 0 |
d2d3f | 06.01.2020 15:45 | 0 |
d2d3f | 06.01.2020 16:00 | 0 |
Hi @Anonymous ,
Do you need a table to connect to the rest of your database or you want a visual with that data?
Best Regards,
Duarte Raminhos
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |