Running Hourly Averages of Data Set

[jstein91694]

I currently have a dataset that each timestamp has values for input, output, and more. I am looking to smooth out the data by calculating a running hourly average for each value. This will take smooth out the plots and eliminate the noise. Any help would be much appreciated!

Thanks!

[V-lianl-msft · Accepted solution]

Hello @jstein91694 ,

Just use the time as the X axis and create the following measure:

Measure = AVERAGEX(VALUES(TABLE[HOUR]),[GAHP XX XXX])

If the problem persists, could you share the dummy data and formula of the [GAHP XXXX]

Best regards
Liang
If this post helps, then consider Accept it as the solution to help other members find it faster.

[jstein91694]

This works, however, I would like to keep Date-Time on my x-axis since I have other visuals that I would also like to include in my plots.

[amitchandak]

@jstein91694 , Create a column like this

Date Hour = Date(year([datetime])+month([datetime])+day([datetime])) + time(hour([datetime]),0,0)

and create a measure like this

calculate( [average measure], filter(allselected(Table),Table[Date Hour] =max(Table[Date Hour])))