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 August 31st. Request your voucher.

Reply
MinuLJ01
Regular Visitor

Dax Measure to sum time between start and end columns based on specific parameters

Hi Power BI Community,

 

I need to be able to show Downtime between two time slots and summarize it in 1 hour increments. I have a formula that works besides to major issues: current day downtime is unable to be show and records with a start time from a previous hour are not included in summation (so if a record start at 10pm and ends at 2am, I am not getting the hour of downtime between 11PM and 12AM to be included in the summation). Please see screenshots below for how I built my measure and the output I am seeing

 

Thanks!

 

MinuLJ01_0-1673970086896.png

MinuLJ01_1-1673970158348.png

MinuLJ01_2-1673970186131.png

MinuLJ01_3-1673970201092.png

MinuLJ01_4-1673970212419.png

 

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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