- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 07-12-2024 07:46 AM | ||
Anonymous
| 06-25-2024 01:54 PM | ||
03-21-2024 09:46 AM | |||
05-17-2018 02:37 PM | |||
06-12-2024 12:06 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |