Convert excel formula to DAX

[Nikitas1]

Hello ,   

how can i convert below Excel formula to Power BI measure to take the average of given values that correspond to hourly quarters to hour values.

=AVERAGE(OFFSET($D$2;(ROW()-ROW($E$2))*4;;4))

I would prefer to take the hourly average in correspondance to each hour of the day , i.e. i have a column contaning the date , another column is the time of the day in ascending order from 1 to 24 and finally thw column with 96 values (one value per quarter of an hour ) . 

To sum up i  would like a DAX query that gives the average of 96 values by 4 in order to transform data drom quarterly arrangement to hourly . 

Thank you in advance !!

[amitchandak]

@Nikitas1 , Based on what I got

Averagex(Summarize(Table, Table[Date], Table[Hour], "_sum", sum(Table[Value])), [_sum])

[Nikitas1]

Well column date hour doesnt exist , only quarter column exists. I want the average for every four quarters not the sum . Thank you my frined for your response.