Forum Discussion

arobinson410's avatar
arobinson410
Regular Visitor
8 years ago
Solved

Bi Hourly Average

So I am fairly new to PowerBI and am having some issues figuring out how to do this:   I have a continuous stream of data that is recorded every minute. I need to be able to calculate the arithmati...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, so that should be something along the lines of:

     

    Column = 
AVERAGEX(
     FILTER(ALL('Table'),
         [YEAR]=EARLIER([YEAR])
              && [MONTH]=EARLIER([MONTH])
              && [DAY]=EARLIER([DAY])
              && [HOUR]<=EARLIER([HOUR]) 
              && [HOUR]>=EARLIER([HOUR])-1
         ),
         [Data Point 1]
    )

    Rinse and repeat for Average 2 column using [Data Point 2] in place of [Data Point 1].

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

OK, so that should be something along the lines of:

 

Column = 
AVERAGEX(
     FILTER(ALL('Table'),
     [YEAR]=EARLIER([YEAR])
          && [MONTH]=EARLIER([MONTH])
          && [DAY]=EARLIER([DAY])
          && [HOUR]<=EARLIER([HOUR]) 
          && [HOUR]>=EARLIER([HOUR])-1
     ),
     [Data Point 1]
)

Rinse and repeat for Average 2 column using [Data Point 2] in place of [Data Point 1].