Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to 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 , 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
User | Count |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
85 | |
75 | |
56 | |
50 | |
45 |