How To Create Measures Over Hours

Hi Engineer Anonymous 
Here is the sample file with solution https://www.dropbox.com/t/Wuw3IVn7ofWHqEr5
Dealing with time in dax is not optimum therefore I recommend that you start with adding an index column to your table. It will cost you one click in power query

The code for the two measures is:

Moving Average 24hrs = 
VAR CurrentIndex =
    MIN (Data[Index] )
VAR ShiftedIndex =
    CurrentIndex - 24
VAR MovingAverage =
    CALCULATE (
        AVERAGE ( Data[Sensor Values] ),
        REMOVEFILTERS ( Data[Date/Time] ),
        Data[Index] >= ShiftedIndex,
        Data[Index] <= CurrentIndex
    )
VAR Result =
    IF ( 
        CurrentIndex >= 24,
        MovingAverage
    )
RETURN
    Result

Above 34 = 
VAR FilterTable =
    FILTER ( 
        VALUES ( Data[Index] ),
        [Moving Average 24hrs] > 34
    )
VAR Result =
    COUNTROWS ( FilterTable )
RETURN
    Result

And this is how thw report looks like

If this answers your query, I kindly request you to mark this reply as acceptable solution. Have agreat day!

Hi Anonymous,

I guess the easiest way is to use the filter pane on the right side. If this is the only information you want to report, I would probably use page filter instead of visual filter.

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ