Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to calculate a rolling 8 hour average of a dataset that is based on a certain ranges of hours during the day. The rolling average is based on the next 7 hours versus the last 7 hours of the data set.
can you share the sample from your data table?
Here is a 24 hour reading of Ozone Detectors at 2 different locations:
SiteName | Date | TimeOnly | RawValue | ParameterName |
ALLENTOWN | 4/9/2019 0:00 | 1/1/1900 0:00 | 37.6604238 | OZONE |
ALLENTOWN | 4/9/2019 1:00 | 1/1/1900 1:00 | 51.8286431 | OZONE |
ALLENTOWN | 4/9/2019 2:00 | 1/1/1900 2:00 | 33.3010703 | OZONE |
ALLENTOWN | 4/9/2019 3:00 | 1/1/1900 3:00 | 25.1576716 | OZONE |
ALLENTOWN | 4/9/2019 4:00 | 1/1/1900 4:00 | 14.1241395 | OZONE |
ALLENTOWN | 4/9/2019 5:00 | 1/1/1900 5:00 | 6.816389 | OZONE |
ALLENTOWN | 4/9/2019 6:00 | 1/1/1900 6:00 | 2.9791184 | OZONE |
ALLENTOWN | 4/9/2019 7:00 | 1/1/1900 7:00 | 8.0167436 | OZONE |
ALLENTOWN | 4/9/2019 8:00 | 1/1/1900 8:00 | 22.1414316 | OZONE |
ALLENTOWN | 4/9/2019 9:00 | 1/1/1900 9:00 | 31.8019635 | OZONE |
ALLENTOWN | 4/9/2019 10:00 | 1/1/1900 10:00 | 34.8055257 | OZONE |
ALLENTOWN | 4/9/2019 11:00 | 1/1/1900 11:00 | 37.7383288 | OZONE |
ALLENTOWN | 4/9/2019 12:00 | 1/1/1900 12:00 | 40.7607785 | OZONE |
ALLENTOWN | 4/9/2019 13:00 | 1/1/1900 13:00 | 46.4895289 | OZONE |
ALLENTOWN | 4/9/2019 14:00 | 1/1/1900 14:00 | 50.0073843 | OZONE |
ALLENTOWN | 4/9/2019 15:00 | 1/1/1900 15:00 | 51.3552042 | OZONE |
ALLENTOWN | 4/9/2019 16:00 | 1/1/1900 16:00 | 49.1176533 | OZONE |
ALLENTOWN | 4/9/2019 17:00 | 1/1/1900 17:00 | 55.3614572 | OZONE |
ALLENTOWN | 4/9/2019 18:00 | 1/1/1900 18:00 | 54.7438224 | OZONE |
ALLENTOWN | 4/9/2019 19:00 | 1/1/1900 19:00 | 50.4877652 | OZONE |
ALLENTOWN | 4/9/2019 20:00 | 1/1/1900 20:00 | 47.0916684 | OZONE |
ALLENTOWN | 4/9/2019 21:00 | 1/1/1900 21:00 | 44.0666383 | OZONE |
ALLENTOWN | 4/9/2019 22:00 | 1/1/1900 22:00 | 43.8841775 | OZONE |
ALLENTOWN | 4/9/2019 23:00 | 1/1/1900 23:00 | 42.9678238 | OZONE |
ALTOONA | 4/9/2019 0:00 | 1/1/1900 0:00 | 12.2370668 | OZONE |
ALTOONA | 4/9/2019 1:00 | 1/1/1900 1:00 | 36.7026419 | OZONE |
ALTOONA | 4/9/2019 2:00 | 1/1/1900 2:00 | 5.3685712 | OZONE |
ALTOONA | 4/9/2019 3:00 | 1/1/1900 3:00 | 4.834824 | OZONE |
ALTOONA | 4/9/2019 4:00 | 1/1/1900 4:00 | 7.3706357 | OZONE |
ALTOONA | 4/9/2019 5:00 | 1/1/1900 5:00 | 9.1384022 | OZONE |
ALTOONA | 4/9/2019 6:00 | 1/1/1900 6:00 | 13.8618639 | OZONE |
ALTOONA | 4/9/2019 7:00 | 1/1/1900 7:00 | 30.866188 | OZONE |
ALTOONA | 4/9/2019 8:00 | 1/1/1900 8:00 | 42.7330005 | OZONE |
ALTOONA | 4/9/2019 9:00 | 1/1/1900 9:00 | 47.8913017 | OZONE |
ALTOONA | 4/9/2019 10:00 | 1/1/1900 10:00 | 48.5476867 | OZONE |
ALTOONA | 4/9/2019 11:00 | 1/1/1900 11:00 | 48.9249702 | OZONE |
ALTOONA | 4/9/2019 12:00 | 1/1/1900 12:00 | 47.0881995 | OZONE |
ALTOONA | 4/9/2019 13:00 | 1/1/1900 13:00 | 55.398166 | OZONE |
ALTOONA | 4/9/2019 14:00 | 1/1/1900 14:00 | 58.7230554 | OZONE |
ALTOONA | 4/9/2019 15:00 | 1/1/1900 15:00 | 57.4781236 | OZONE |
ALTOONA | 4/9/2019 16:00 | 1/1/1900 16:00 | 54.7125648 | OZONE |
ALTOONA | 4/9/2019 17:00 | 1/1/1900 17:00 | 54.3139076 | OZONE |
ALTOONA | 4/9/2019 18:00 | 1/1/1900 18:00 | 52.5315857 | OZONE |
ALTOONA | 4/9/2019 19:00 | 1/1/1900 19:00 | 51.6327021 | OZONE |
ALTOONA | 4/9/2019 20:00 | 1/1/1900 20:00 | 50.2883429 | OZONE |
ALTOONA | 4/9/2019 21:00 | 1/1/1900 21:00 | 47.9600911 | OZONE |
ALTOONA | 4/9/2019 22:00 | 1/1/1900 22:00 | 42.757117 | OZONE |
ALTOONA | 4/9/2019 23:00 | 1/1/1900 23:00 | 37.6118286 | OZONE |
I need to calculate an hourly rolling average for Ozone over an 8 hour period (Time + 7 Hours Forward) per Site. I'm hoping to do this in DirectQuery Mode.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |