Forum Discussion

Saranya3_d's avatar
Saranya3_d
Helper I
6 years ago

Percentile

<top>  Hi Experts, I’m looking for percentile calculation in powerbi report. The In-build formula is not working out for my requirement, so I have written an query to fetch the outcome as per the ...
Saranya3_d's avatar
Saranya3_d
Helper I
6 years ago

screenshot of pbix

MFelix's avatar
MFelix
Super User
6 years ago

Hi Saranya3_d ,

 

You can you share a file trough onedrive, googledrive, wetransfer or similar links.

 

Are you abble to share a file?

  • Saranya3_d's avatar
    Saranya3_d
    Helper I
    6 years ago

    Mflexi,

     

    Pbix file has been placed in the below drive. Please help me to arrive the precentile. 

     

    https://1drv.ms/u/s!AryZvCsTToGkiFbVLcHPg7eaneEr

     

    PS:  I will write a query in column to change the "Overall MTTR in Hours" into "HH:MM:SS" format. All the data's are available in the single table like Priority, Ticket ID (unique filed), Ovearll MTTR in hours, overall mttr in min, created and resolved time. 

     

    Thanks,

    Saranya

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Is it possible to share the excel file?

       

      I need to make some changes in order not having duplicated rankings.