Summing values across multiple records based on two separate Date slicers

[AnonEMoose]

Hello,

A pet project I've been working on is a resource tracking report based on the hours our team spends on supporting other teams and regions. We are approaching 400 entries for these recorded tasks looking similar to below. 

Task Name	Brief description of the issue	Assigned to	Start Date	End Date	Duration in hours	Team supported	Region	off hours (# of hours)	Planned work
Team's  Meetings	Daily Standup Meetings	John Smith	7/24/2023	7/28/2023	1	A	North		Yes
Projects	License Reduction	Mary Jane	7/25/2023	7/25/2023	0.5	B	South		Yes
Admin Work	Clean up servers	Luke Skywalker	8/1/2023	8/4/2023	3	C	West		Yes

We are using two seperate date columns to track the ranges of time during which our different work items are taking place. This is my current roadblock since most date experessions I've seen so far are expecting a range of date entries from a single date column. Our report as of now is using two date slicers to filter work hours based on Start Date and End Date, so I'm curious to see how (if possible) we could perform a calculation that multiplies working hours in a day by the number of work days between two specified dates from different columns. Any help would be appreciated 🙂

[Ashish_Mathur]

Hi,

Based on the data that you have shared, show the exact expected result.

[lbendlin]

Read about NETWORKDAYS() and DAYSBETWEEN()