Forum Discussion

Seira088's avatar
Seira088
Frequent Visitor
6 years ago

Percentile calculation issue

I have this table below for comparison, Excel value are the expected one however Power BI result returns some incorrect values (italicized values).  Formula Used is  95th Percentile = PERCENTILE...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Seira088 ,

You can check if there is a 0 in the field 'Consolidated Data'[Value] in the Query Editor, and if so, replace it with null. Or have you made some other conversions?

If it doesn't meet your requirement, kindly share your sample data if you don't have any Confidential Information.

 

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Seira088's avatar
Seira088
Frequent Visitor
6 years ago

Hi v-joesh-msft ,

I actually filtered out 0 values. so no 0 value is present in the 'Consolidated Data'[Value] column.

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi Seira088 ,

    Could you share your sample data for us to have a test if you don't have any Confidential Information?

     

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Seira088's avatar
      Seira088
      Frequent Visitor
      6 years ago

      Hi v-joesh-msft ,

      here's the data:

      DataDateValue
      Data 106/08/2019 0:008.9
      Data 107/08/2019 0:0012.8
      Data 108/08/2019 0:00394.6
      Data 109/08/2019 0:00427.9
      Data 110/08/2019 0:00771.2
      Data 111/08/2019 0:001599.8
      Data 112/08/2019 0:00799.7
      Data 113/08/2019 0:005253.6
      Data 115/08/2019 0:005972.6
      Data 116/08/2019 0:006472.5
      Data 117/08/2019 0:006611.5
      Data 118/08/2019 0:0013257.2
      Data 119/08/2019 0:006631
      Data 120/08/2019 0:006632.7
      Data 121/08/2019 0:006651.5
      Data 122/08/2019 0:007063.5
      Data 123/08/2019 0:007064.4
      Data 124/08/2019 0:007675.8
      Data 125/08/2019 0:0015892.8
      Data 126/08/2019 0:007947.1
      Data 127/08/2019 0:007948.8
      Data 128/08/2019 0:008048.1
      Data 129/08/2019 0:008094.8
      Data 130/08/2019 0:008276.2
      Data 131/08/2019 0:008291.5
      Data 101/09/2019 0:0017500.8
      Data 102/09/2019 0:008965.3
      Data 103/09/2019 0:008967.9
      Data 105/09/2019 0:009013.4
      Data 106/09/2019 0:009014
      Data 107/09/2019 0:009028.1
      Data 108/09/2019 0:0018056.8
      Data 109/09/2019 0:009033.2
      Data 110/09/2019 0:009033.7
      Data 111/09/2019 0:009061.1
      Data 112/09/2019 0:009111.6
      Data 113/09/2019 0:009151.4
      Data 114/09/2019 0:009154.8
      Data 115/09/2019 0:0018451.6
      Data 116/09/2019 0:009317.5
      Data 117/09/2019 0:009318.7
      Data 118/09/2019 0:009341
      Data 119/09/2019 0:009370.3
      Data 120/09/2019 0:009392.1
      Data 121/09/2019 0:009406
      Data 122/09/2019 0:0018816.4
      Data 123/09/2019 0:009408.1
      Data 124/09/2019 0:009409.5
      Data 125/09/2019 0:009514
      Data 126/09/2019 0:009719.2
      Data 127/09/2019 0:009776.2
      Data 128/09/2019 0:009804.6
      Data 129/09/2019 0:0019894.4
      Data 130/09/2019 0:009949.9
      Data 201/08/2019 0:009383.1
      Data 202/08/2019 0:009383.1
      Data 203/08/2019 0:009372.5
      Data 204/08/2019 0:0018723.6
      Data 206/08/2019 0:009353.6
      Data 207/08/2019 0:009558.1
      Data 208/08/2019 0:0010420.9
      Data 209/08/2019 0:0010626.5
      Data 210/08/2019 0:0010762.1
      Data 211/08/2019 0:0021776.8
      Data 212/08/2019 0:0011037.3
      Data 213/08/2019 0:0011095.6
      Data 215/08/2019 0:0011419.9
      Data 216/08/2019 0:0011550.3
      Data 217/08/2019 0:0011684.6
      Data 218/08/2019 0:0023595.2
      Data 219/08/2019 0:0011968
      Data 220/08/2019 0:0012070.5
      Data 221/08/2019 0:0012245.1
      Data 222/08/2019 0:0012348.1
      Data 223/08/2019 0:0012455.8
      Data 224/08/2019 0:0012577.1
      Data 225/08/2019 0:0025384.2
      Data 226/08/2019 0:0012817.3
      Data 227/08/2019 0:0012917.5
      Data 228/08/2019 0:0013025.3
      Data 229/08/2019 0:0013118.7
      Data 230/08/2019 0:0013221
      Data 231/08/2019 0:0013306.4
      Data 201/09/2019 0:0026852.8
      Data 202/09/2019 0:0013577.2
      Data 203/09/2019 0:0013673.6
      Data 205/09/2019 0:0013983.9
      Data 206/09/2019 0:0013975
      Data 207/09/2019 0:0013989.5
      Data 208/09/2019 0:0028010.2
      Data 209/09/2019 0:0013966.3
      Data 210/09/2019 0:0014147.5
      Data 211/09/2019 0:0014254.6
      Data 212/09/2019 0:0014330.5
      Data 213/09/2019 0:0014422.7
      Data 214/09/2019 0:0014521.2
      Data 215/09/2019 0:0029233.6
      Data 216/09/2019 0:0014709.9
      Data 217/09/2019 0:0014818.5
      Data 218/09/2019 0:0014883.1
      Data 219/09/2019 0:0014981.5
      Data 220/09/2019 0:0015061.8
      Data 221/09/2019 0:0015139.8
      Data 222/09/2019 0:0030481.4
      Data 223/09/2019 0:0015264.3
      Data 224/09/2019 0:0015264.4
      Data 225/09/2019 0:0015250.2
      Data 226/09/2019 0:0015250.9
      Data 227/09/2019 0:0015272.2
      Data 228/09/2019 0:0015292.8
      Data 229/09/2019 0:0030617.4
      Data 230/09/2019 0:0015334