Forum Discussion
Ghaston
Helper I
Helper Irolling average by half hour
hi i'm using power query to connect with a SQL base that refeshes every 5 min. I have a column named "Date_Heure" in the " Date/time " form. I have a column named "Arche-Total_Entres" that i wan...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Ghaston,
That can't work. What's the type of column [Date_Heure]? Seems it isn't a DateTime type. Please check out. The error message is clear. We should check the data type and its values which should be a normal time. For example, 25: 30: 00 isn't a time.
Best Regards,
Dale
GhastonHelper I
Helper I
it's a date/time type