Forum Discussion

Sudharsanan's avatar
Sudharsanan
Icon for Helper III rankHelper III
3 years ago
Solved

percentile value in DAX is different compared with Excel

Hi All,   I am see diffence in values while calculating Percentile for 25% in dax and calculating the same in excel. does anyone have any idea? i am getting 15:38 in excel and 10:50 in dax.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Sudharsanan ,

     

    There is no time duration in DAX, only simple time and date, but there is duration in PQ, so it is normal for DAX and Excel to have differences. It is recommended to use PQ to calculate.

    Duration functions - PowerQuery M | Microsoft Learn

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Sudharsanan ,

 

There is no time duration in DAX, only simple time and date, but there is duration in PQ, so it is normal for DAX and Excel to have differences. It is recommended to use PQ to calculate.

Duration functions - PowerQuery M | Microsoft Learn

 

Best Regards,

Liu Yang

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