Forum Discussion

Helper I

7 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

v-jiascu-msft

Microsoft Employee

7 years ago

Hi Ghaston,

I'm afraid we can't do it like that. Because we can't get the latest time due to the limits of Direct Query. How about every half an hour based on actual time?

1. Create a calculated column.

Column =
IF (
    TIMEVALUE ( 'exampledata'[Date_Heure] ) > TIME ( HOUR ( [Date_Heure] ), 30, 0 ),
    DATEVALUE ( [Date_Heure] ) + TIME ( HOUR ( [Date_Heure] ), 30, 0 ),
    DATEVALUE ( [Date_Heure] ) + TIME ( HOUR ( [Date_Heure] ), 0, 0 )
)

2. Put the column in the X-axis.