Datediff for a day gives different values

[krecks1234]

Hi there,

I have a calculated Table with different dates in there.

I have now three different columns which calculates the Datediff between them.
1. Is in Second
2. Is in Second / (24 * 60 * 60)
3. Is in Days

My question is now how Power BI is handeling the Datediffs for Days.

As you can see some Datediffs in days are getting 1 even if the seconds are the same.

kind regards

[Icey · Accepted solution]

Hi @krecks1234 ,

You can refer to this Example.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.