Calculating 2-hour averages

[arians]

Hi,

I have a dataset with values recroded every 15 minutes (in date and time format, see the example below). I am trying to averages within different time intervals. For example, I am interested to know the rolling 2-hour average values (i.e. each eight 15-min datapoints to be aggregated together). Does anyone know of a DAX function that could help me achieve this? I have tried most of the "Time Intelligence" fuctions in power BI, but those are applied to year, month and day. I haven't found a function that could help with minutely and hourly data.

Appreciate your thoughts.

AS

[v-chuncz-msft · Accepted solution]

@arians,

You may refer to the post below and use AVERAGEX Function.

https://community.powerbi.com/t5/Desktop/4-weeks-sales-in-column/m-p/319863#M142375