2 Same Dates Not Resulting to 0 (Date Difference)

[Anonymous]

Hi, Community. Good evening to all. I have a question regarding date difference. My dates are the same, though there are some differences in time. But I want to have a result of 0. What should be change in my DAX?

[Anonymous · Accepted solution]

It is solved now. 🙂 I edited my DAX with this:

[PabloDeheza]

Hi @Anonymous !
It look like your calculation us Summing the column "Is Working Day" which probably has a 1 for each working day, if what you want is to calculate the difference between those dates then try using the DATEDIFF() function.
DATEDIFF(  'Fiscal Calendar'[Fiscal Day], 'PostRelease_Completed'[Post Release Tasks - Date of Entry], 'PostRelease_Completed'[Final Complete Date]

Let me know if that helps!

[Anonymous]

I have tried that, but it's having errors if I wan't to consider the working days. 😕