topic Rolling Averages in Developer https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/646245#M18826 <P><EM>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.&nbsp; The rolling average is based on the next&nbsp;7 hours versus the last&nbsp;7 hours of the data set.&nbsp; </EM></P> Fri, 15 Mar 2019 12:31:51 GMT mahouser 2019-03-15T12:31:51Z Rolling Averages https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/646245#M18826 <P><EM>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.&nbsp; The rolling average is based on the next&nbsp;7 hours versus the last&nbsp;7 hours of the data set.&nbsp; </EM></P> Fri, 15 Mar 2019 12:31:51 GMT https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/646245#M18826 mahouser 2019-03-15T12:31:51Z Re: Rolling Averages https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/647509#M18840 <P>can you share the sample from your data table?</P> Mon, 18 Mar 2019 13:35:18 GMT https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/647509#M18840 Stachu 2019-03-18T13:35:18Z Re: Rolling Averages https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/666733#M19062 <P>Here is a 24 hour reading of Ozone Detectors at 2 different locations:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SiteName</TD><TD>Date</TD><TD>TimeOnly</TD><TD>RawValue</TD><TD>ParameterName</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 0:00</TD><TD>1/1/1900 0:00</TD><TD>37.6604238</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 1:00</TD><TD>1/1/1900 1:00</TD><TD>51.8286431</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 2:00</TD><TD>1/1/1900 2:00</TD><TD>33.3010703</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 3:00</TD><TD>1/1/1900 3:00</TD><TD>25.1576716</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 4:00</TD><TD>1/1/1900 4:00</TD><TD>14.1241395</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 5:00</TD><TD>1/1/1900 5:00</TD><TD>6.816389</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 6:00</TD><TD>1/1/1900 6:00</TD><TD>2.9791184</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 7:00</TD><TD>1/1/1900 7:00</TD><TD>8.0167436</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 8:00</TD><TD>1/1/1900 8:00</TD><TD>22.1414316</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 9:00</TD><TD>1/1/1900 9:00</TD><TD>31.8019635</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 10:00</TD><TD>1/1/1900 10:00</TD><TD>34.8055257</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 11:00</TD><TD>1/1/1900 11:00</TD><TD>37.7383288</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 12:00</TD><TD>1/1/1900 12:00</TD><TD>40.7607785</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 13:00</TD><TD>1/1/1900 13:00</TD><TD>46.4895289</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 14:00</TD><TD>1/1/1900 14:00</TD><TD>50.0073843</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 15:00</TD><TD>1/1/1900 15:00</TD><TD>51.3552042</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 16:00</TD><TD>1/1/1900 16:00</TD><TD>49.1176533</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 17:00</TD><TD>1/1/1900 17:00</TD><TD>55.3614572</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 18:00</TD><TD>1/1/1900 18:00</TD><TD>54.7438224</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 19:00</TD><TD>1/1/1900 19:00</TD><TD>50.4877652</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 20:00</TD><TD>1/1/1900 20:00</TD><TD>47.0916684</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 21:00</TD><TD>1/1/1900 21:00</TD><TD>44.0666383</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 22:00</TD><TD>1/1/1900 22:00</TD><TD>43.8841775</TD><TD>OZONE</TD></TR><TR><TD>ALLENTOWN</TD><TD>4/9/2019 23:00</TD><TD>1/1/1900 23:00</TD><TD>42.9678238</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 0:00</TD><TD>1/1/1900 0:00</TD><TD>12.2370668</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 1:00</TD><TD>1/1/1900 1:00</TD><TD>36.7026419</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 2:00</TD><TD>1/1/1900 2:00</TD><TD>5.3685712</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 3:00</TD><TD>1/1/1900 3:00</TD><TD>4.834824</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 4:00</TD><TD>1/1/1900 4:00</TD><TD>7.3706357</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 5:00</TD><TD>1/1/1900 5:00</TD><TD>9.1384022</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 6:00</TD><TD>1/1/1900 6:00</TD><TD>13.8618639</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 7:00</TD><TD>1/1/1900 7:00</TD><TD>30.866188</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 8:00</TD><TD>1/1/1900 8:00</TD><TD>42.7330005</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 9:00</TD><TD>1/1/1900 9:00</TD><TD>47.8913017</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 10:00</TD><TD>1/1/1900 10:00</TD><TD>48.5476867</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 11:00</TD><TD>1/1/1900 11:00</TD><TD>48.9249702</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 12:00</TD><TD>1/1/1900 12:00</TD><TD>47.0881995</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 13:00</TD><TD>1/1/1900 13:00</TD><TD>55.398166</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 14:00</TD><TD>1/1/1900 14:00</TD><TD>58.7230554</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 15:00</TD><TD>1/1/1900 15:00</TD><TD>57.4781236</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 16:00</TD><TD>1/1/1900 16:00</TD><TD>54.7125648</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 17:00</TD><TD>1/1/1900 17:00</TD><TD>54.3139076</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 18:00</TD><TD>1/1/1900 18:00</TD><TD>52.5315857</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 19:00</TD><TD>1/1/1900 19:00</TD><TD>51.6327021</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 20:00</TD><TD>1/1/1900 20:00</TD><TD>50.2883429</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 21:00</TD><TD>1/1/1900 21:00</TD><TD>47.9600911</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 22:00</TD><TD>1/1/1900 22:00</TD><TD>42.757117</TD><TD>OZONE</TD></TR><TR><TD>ALTOONA</TD><TD>4/9/2019 23:00</TD><TD>1/1/1900 23:00</TD><TD>37.6118286</TD><TD>OZONE</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to calculate an hourly&nbsp;rolling average for Ozone over an 8 hour period (Time +&nbsp;7 Hours Forward) per Site.&nbsp; I'm hoping to do this in DirectQuery Mode.</P> Wed, 10 Apr 2019 17:49:39 GMT https://community.fabric.microsoft.com/t5/Developer/Rolling-Averages/m-p/666733#M19062 mahouser 2019-04-10T17:49:39Z