Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Running Hours Calculation from Downtime Data

Hi, 

 

I have a table called Downtime that has columns StartDate and Loss for each event. I created a Date table that has each day in it so I am using that Date table to get a Hours column that gives 24 hours in each day. 

 

I want to get Date[Hours]-Downtime[Loss] for each day but I'm not sure how to tie these two tables together and how to get this column/measure.

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@Anonymous , Try a measure like

 

countdistinct(Downtime[Date])*24 - Sum(Downtime[Loss])

 

or

 

countdistinct(Date[Date])*24 - Sum(Downtime[Loss])

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

Syndicated - Outbound

@Anonymous , Try a measure like

 

countdistinct(Downtime[Date])*24 - Sum(Downtime[Loss])

 

or

 

countdistinct(Date[Date])*24 - Sum(Downtime[Loss])

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)