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,

I am not sure of how much i can help but share the link from where i can download your PBI file.  In that file, please clearly show the result you are expecting to see.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ashish_Mathur 

 

here is the link for the file

https://drive.google.com/open?id=1E-OOUOH2GQhiswg6OBfyX3BsTTFsNEwl

 

the expected output which i have marked in red are all the blanks in the matrix reports that need a value

so 0.00 would be when i am calculating per month the sum of downtime. if there is no downtime, then i should see 0.00

 

when i work out the uptime % in the bottom table. i need the calculations to say 100% if there has been no affected downtime for that product for that month,

 

  • 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