Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |