Generated Datetime table

[kirbynguyen]

I am creating a datetime table with a row for every 5 minutes. Here is my code:

DateTime =
GENERATESERIES (
DATEVALUE ( MIN ( Table[Date] ) ),
DATEVALUE ( MAX ( Table[Date] ) ),
TIME ( 0, 5, 0 )
)

The values for Table[Date] actually don't matter and can be hard coded, so no actual data is needed to create this. For some reason, though, the datetime table works for about 20 days and then is off by one second. Instead of 1/21/2022 5:10:00 PM, it shows 1/21/2022 5:09:59 PM, and then every data point after that is off by one second (everything ends with 59 instead of 00.

Why is this happening and how do I fix it?

[HotChilli]

Please see this thread:

https://community.fabric.microsoft.com/t5/Desktop/Time-series/m-p/3421416#M1135931 

I didn't investigate any further since the problem was solved but there will probably be a better way to generate times without having to do this