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,
I'm having an issue creating a column/measure that tells me the elapsed time during 2 different data states.
I have a single column with date/time, and another with a detected state: "MOTION_DETECTED" and "NO_MOTION_DETECTED".
Ideally, i'd like a column/measure that tells me the elapsed minutes from a motion has been detected, until it returns that no motion has been detected. Similarly, i would like a column/measure that tells me the elapsed time from no detected motion, until motion is detected.
Any tips? Data sample can be seen below:
Solved! Go to Solution.
Sorry for the late reply!
I found a solution to my problem by grouping the DeviceID together, and then indexing it by the timestamp. This guide was helpful in case others have a similar wish:
https://radacad.com/power-query-transformation-pattern-convert-status-log-dates-table-to-start-and-e...
Hi @Herdichek ,
Could you pls show what you want expected output reusult according your base data?
Best Regards
Lucien
Sorry for the late reply!
I found a solution to my problem by grouping the DeviceID together, and then indexing it by the timestamp. This guide was helpful in case others have a similar wish:
https://radacad.com/power-query-transformation-pattern-convert-status-log-dates-table-to-start-and-e...
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |