percentile value in DAX is different compared with Excel

[Sudharsanan]

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

[v-yangliu-msft · Accepted solution]

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.