Forum Discussion
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 giv...
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.
amitchandak
Super User
Super UserAnonymous , 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.