Forum Discussion

radiator's avatar
radiator
Frequent Visitor
1 year ago
Solved

Datediff - many wrong results

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

 

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

2 Replies

  • 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. 

  • radiator's avatar
    radiator
    Frequent Visitor

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