Question regarding a calculation in Power BI. The need is to calculate 'Total Hours of Overtime for a given period'. Input variables:
- Time = date range that is selected through a Slicer.
- Number of resources 'active' also updated based on the dates selected through the Slicer.
- Activities will for tasks that exclude any form of Leave.
- Overtime will be any excess hours more than 45 hours for a week (for all 'active' resources).
Looking forward to the forum's response.
Thanks and regards,