DATEDIFF

[jolundin]

The datediff function in the below column calculates the incorrect difference in minutes for one line. The value should return 37 minutes and returns 555 minutes. There are no summerizations with this table and the calculation is fine for all other records.

[v-robertq-msft]

Hi,

According to my test, the Datediff() function can get the correct result in my side:

If you still have a problem, would you like to post a download link of the pbix file with this issue without the sensitive data if it’s pssible and we can help you to check if it’s an existing issue in the Power BI?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin