difference in values for Duration.days and datediff for same dates

[KV2022]

Hi, I am trying to find the difference between two dates in days. Why am i getting two different values?

the first picture is the calculated column .

the second picture is the custom column in PQ editor which uses duration.days

[amitchandak · Accepted solution]

@KV2022 , Please use Truncated Date

In Power Query

DateTime.Date([Start Date])

and In Dax

DateValue([Start Date])

Use these two in formula and check

[KV2022]

I used DateTime.Date in the custom column. thanks