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.
I have the below data table that containts users logs. After the substraction between last log out and First log in I have found the total working hours duration. I have tried to add a calculated column that brings the latest event and then make a substraction but my 16 GB Ram computer can't perform the calculation since I have almost 53.000 records for the last month.
My question is if there is any way that I can measure the total break time having only a column with the time event, the event itself (In, Out).
Hi @Anonymous,
What do you mean "measure the total break time having only a column with the time event, the event itself (In, Out)"? What is the current measure formula you used?
Regards,
Yuliana Gu
there is the event timestamp column that records each event (direction column). For each day a user by hitting his/her card a new event is being recorded. I want to measure the total time he/she spent on break (difference out - in and ignore check) per day during his/her working hours. The right picutre shows the total working hours per day and it measures Last out - First In
(
)
* Last hit = MAX(Data[Event Time stamp])
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |