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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ashish_Mathur  any thoughts?

 

thanks

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Ashish_Mathur 

    thankyou. im trying to get an understand of the unpivot other columns step you applied. my real spreadsheet has many more columns. im trying to understand what i should be pivoting or not?

     

    thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      Unpivot all columns other than Start time and End time columns.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Ashish_Mathur 

        thanks. i have the first 2 tables working great now

         

        im doing something wrong when it comes to calculating the % table. the numbers do not seem to add up

        cant seem to find what i have done

  • 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!