Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Uptime

hi, looking for some help   trying to work out a uptime availability for a cloud service, i have working in excel but wish to move it over to powerbi to do all the calculations   for the ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

ThoSt's avatar
ThoSt
Frequent Visitor
5 years ago

Hi Ashish_Mathur 

thanks for this example! I have looked into this but cannot explain the following:

When enabling Subtotals, the numbers seem off:

 

Isn't the calculation of the total the average across the row? If yes, then how can the actual total be lower than any of the values in the columns?

Is there a misunderstanding on my part?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    For that example (as old as 2 years), there may not have been a need to show subtotals.  that being said, the result in the Total column does seem wrong.  Start a new thread with your data, describe your question and show the expected result.

  • ThoSt's avatar
    ThoSt
    Frequent Visitor
    5 years ago

    Hi Ashish_Mathur ,

    no problem just wanted to find out if I am misunderstanding something here or if it's really wrong.

    I will create a new thread with my data 🙂 thanks!