Forum Discussion

Ghaston's avatar
Ghaston
Icon for Helper I rankHelper I
8 years ago

rolling 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...
Need Help
Ghaston's avatar
Ghaston
Icon for Helper I rankHelper I
8 years ago


it's a date/time type

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Ghaston,

 

The formula worked well in my test. Please refer to the snapshot below. Do you have any other details you can share?

rolling_average_by_half_hour2

 

 

Best Regards,

Dale