Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

DATEDIFF

Submitted by Anonymous on ‎10-25-2021 01:15 PM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-robertq-msft
Community Support
Community Support
‎10-25-2021 07:33 PM

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
Community Support
‎10-25-2021 07:33 PM
Status changed to: Investigating
 
Idea Statuses