Calculate total time in meeting during work day.

[Nickhe]

Hi! 

So i'm trying to do a report where we calculate how much time each person is in a meeting per day but I can't figure out how to mesure it and show it in a graph.

So the plan is to be able to see how much that % person time is spend in meeting for a specific day, month, year etc.

Fields:

User(String):  , Meeting Start time(datetime) ,  Meeting end time(datetime), duration (datetime)

[Anonymous]

Hi @Nickhe 

I have found some scenarios that are similar to your needs, you can refer to them, maybe it will give you some inspiration and help to build a model .

https://community.powerbi.com/t5/Desktop/Calculating-Network-Hours-Working-Hours/m-p/673423

https://community.powerbi.com/t5/Desktop/How-to-calculate-net-working-days/m-p/421021

https://community.powerbi.com/t5/Desktop/Calculating-working-hours-between-2-dates-disregarding-week...

https://community.powerbi.com/t5/Desktop/Number-of-working-days/m-p/22842

https://community.powerbi.com/t5/Desktop/Calculating-Working-hours/m-p/374255

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You should be able to sum the duration column and divide by the # of hrs in a working day. However, any conflicting meetings would be double counted. If so, I would recommend you set up a Time table in your model with a row for every 15 or 30 min. You can then split your Start and End Time columns into separate Date and Time columns. With no relationship between the tables, you can write a DAX measure that iterates over each row in the Time table (for each Date) and checks if there is at least one meeting at that time to be counted (Start Time <= this time && End Time >= this time).

Please also see this article - Calculate and Format Durations in DAX – Hoosier BI

Pat