Forum Discussion
Solved
Calculate time differences (multiple dates) in the same column filter by name in different column
I hope someone can help. I have searched many places to hope for an answer. I have this data, a column contains date and time. Another column has usernames. What I need to do is to count all of t...
Thank you so much for your help. This is what my boss is looking for.
Hi peifc75
You can split the column to date and time and use a dim timetable with the needed slots.
For more information, please refer to the linked video :
https://www.youtube.com/watch?v=-q7v56p192M&t=2s
or (less recommended solution) from PQ add column from example to the date time column :
Than you will get a column with a fixed date time to hours and use it as filter
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly