Forum Discussion

KV2022's avatar
KV2022
Helper II
3 years ago
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 co...
  • amitchandak's avatar
    3 years ago

    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