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 

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    I cannot tell what mistake you are committing.  Compare your file to the solution file i uploaded.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Ashish_Mathur 

    all good. the relationship between the tables wasnt correct in my file. i had fixed that and i have validated the data

    thank you for the help

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.