Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
If I have a service or a server that has been online since 1st Jan 2017 00:00:00 and went down 2nd Feb 2017 02:00:00 it's easy to calculate the number of minutes in between the two dates using dax. But how do I calculate the number of minutes that the service was up in January and the number of minutes it was up in February?
I'm trying to calculate a service availability calculation in Power BI with a table of data for multiple services linked to a calendar table. It as if I need to create some sort of calculated column in the calendar table that will accumlate the minutes per day each service was up for. Can anyone shed any light on this if I'm making sense that is?
Solved! Go to Solution.
You can reference the solution in this Time calculations - Hours per month over different periods , it is very similar to your case.
You can reference the solution in this Time calculations - Hours per month over different periods , it is very similar to your case.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |