Forum Discussion
Helper IIIpercentile 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.
| Time |
| 0:00:48 |
| 0:03:12 |
| 0:06:26 |
| 0:06:29 |
| 0:06:39 |
| 0:06:58 |
| 0:08:17 |
| 0:08:22 |
| 0:08:23 |
| 0:08:24 |
| 0:09:03 |
| 0:09:27 |
| 0:09:53 |
| 0:10:11 |
| 0:10:50 |
| 0:11:15 |
| 0:12:11 |
| 0:12:42 |
| 0:13:05 |
| 0:13:08 |
| 0:13:12 |
| 0:13:17 |
| 0:13:18 |
| 0:13:56 |
| 0:14:00 |
| 0:14:03 |
| 0:14:09 |
| 0:14:11 |
| 0:14:50 |
| 0:14:58 |
| 0:16:18 |
| 0:16:40 |
| 0:16:41 |
| 0:16:48 |
| 0:18:17 |
| 0:18:20 |
| 0:18:29 |
| 0:18:34 |
| 0:19:45 |
| 0:19:48 |
| 0:19:59 |
| 0:20:06 |
| 0:20:45 |
| 0:21:39 |
| 0:22:06 |
| 0:22:12 |
| 0:22:28 |
| 0:22:40 |
| 0:23:01 |
| 0:23:02 |
| 0:23:28 |
| 0:23:37 |
| 0:23:43 |
| 0:23:44 |
| 0:25:03 |
| 0:25:42 |
| 0:25:51 |
| 0:26:14 |
| 0:26:25 |
| 0:26:47 |
| 0:27:26 |
| 0:27:35 |
| 0:28:12 |
| 0:28:28 |
| 0:28:34 |
| 0:29:03 |
| 0:30:23 |
| 0:30:26 |
| 0:30:38 |
| 0:30:47 |
| 0:31:15 |
| 0:32:16 |
| 0:32:21 |
| 0:32:45 |
| 0:32:55 |
| 0:33:38 |
| 0:33:49 |
| 0:34:08 |
| 0:34:21 |
| 0:34:39 |
| 0:34:45 |
| 0:34:52 |
| 0:35:45 |
| 0:35:50 |
| 0:36:13 |
| 0:37:10 |
| 0:37:15 |
| 0:39:02 |
| 0:39:11 |
| 0:41:07 |
| 0:41:16 |
| 0:43:16 |
| 0:44:26 |
| 0:44:45 |
| 0:45:21 |
| 0:45:30 |
| 0:46:55 |
| 0:47:42 |
| 0:52:44 |
| 0:52:53 |
| 0:53:04 |
| 0:55:35 |
| 0:56:18 |
| 0:57:01 |
| 0:57:05 |
| 0:59:02 |
| 1:00:05 |
| 1:01:35 |
| 1:02:19 |
| 1:03:03 |
| 1:06:17 |
| 1:09:30 |
| 1:11:10 |
| 1:17:04 |
| 1:23:11 |
| 1:35:22 |
| 1:41:42 |
| 1:54:06 |
| 1:58:10 |
| 2:20:48 |
| 2:23:52 |
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.
1 Reply
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.