Max value of time window

kadapavel

Here are the steps to get every 3rd Second and related Maximum Value for a 3 second period

First I added 2 calculated Columns to filter out every 3rd second

Second =
SECOND ( Table1[SignalTimeStamp] )

3rd_Second =
IF (
    ( Table1[Second] / 3 )
        - INT ( Table1[Second] / 3 )
        = 0,
    "3rd Second",
    "Others"
)

Final step is to get the Maximum Value for the 3 seconds interval. I used following MEASURE to do this

Max_Value =
CALCULATE (
    MAX ( Table1[Value] ),
    TOPN (
        3,
        FILTER (
            ALL ( Table1 ),
            Table1[SignalTimeStamp] <= SELECTEDVALUE ( Table1[SignalTimeStamp] )
        ),
        Table1[SignalTimeStamp], DESC
    )
)