Forum Discussion
Solved
difference in values for Duration.days and datediff for same dates
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
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
2 Replies
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
I used DateTime.Date in the custom column. thanks
