Datediff - many wrong results

[radiator]

Hi all,

I discovered there were issues with my datediff. It works and then it doesn't. When looking at a time period it looks like it starts not working when we are entering a new month. It works when the line is flat. Any idea what the issue here is?

Best regards,

radiator

[radiator · Accepted solution]

Nevermind, the stoptime column had turned into text after doing some query changes. Back to datetime and everything works fine.

[ToddChitt]

We will need to see the DAX or M code that you have in place, along with some sample data.

Also, what do you HOPE to have as an expected output.

Help us help you.