Forum Discussion
KV2022
3 years agoHelper II
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...
- 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
amitchandak
3 years agoSuper User
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
3 years agoHelper II
I used DateTime.Date in the custom column. thanks