Forum Discussion
Up time and Down Time
Hi Guys,
Im working on a report for Server/Application Up and down time.
The Data i will be given on a monthly Basis is attached in a CSV
It shows the Critical system with the outage start time and end time and if the Outage was planned.
I Would Like to set up a PBIX to show the "Critical System" with the Up and down time throughout the month.
In line Chart BY day of the month. to show the down time and for how long.
Im hoping for some help on how i can do this.
Cheers
Dan
| Critical System | Outage Start Date/Time | Outage End Date/Time | Planned or Unplanned? |
| Servers / Storage | 22/04/2022 08:00 | 22/04/2022 08:05 | Unplanned |
| Application | 19/04/2022 06:00 | 19/04/2022 16:00 | Planned |
| Application | 20/04/2022 09:00 | 20/04/2022 10:00 | Unplanned |
2 Replies
- Greg_Deckler
Community Champion
DanielHolland Seems like you need a variation of MTBF. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __PreviousThank you Greg, I did see this Article before i Posted the question.
Its really Usefull, But i couldnt get it to work for my end report
- Im looking to select the month and then it show the Uptime and down time in a line graph By Day of the month ofthe critical system, Similar to the Image you included in your article.
Using the CSV data that I mentioned in the question.
Apologies on the novice post.
