Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
AnonEMoose
Frequent Visitor

Summing values across multiple records based on two separate Date slicers

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 NameBrief description of the issue Assigned to Start DateEnd DateDuration in hoursTeam supportedRegionoff hours (# of hours)Planned work
Team's  MeetingsDaily Standup Meetings John Smith7/24/20237/28/20231ANorth Yes
ProjectsLicense ReductionMary Jane7/25/20237/25/20230.5BSouth Yes
Admin WorkClean up serversLuke Skywalker8/1/20238/4/20233CWest 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 🙂

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Read about NETWORKDAYS() and DAYSBETWEEN()

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.