cancel
Showing results for 
Search instead for 
Did you mean: 

DATEDIFF

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.

jolundin_0-1635192794033.png

 

Status: Investigating
Comments
v-robertq-msft
Community Support

Hi,

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

vrobertqmsft_0-1635215591589.png

 

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

v-robertq-msft
Community Support
Status changed to: Investigating