Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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!

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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.

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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.