Running Hours Calculation from Downtime Data

[TaylorG]

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!

[amitchandak · Accepted solution]

@TaylorG , 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.