Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure Filter not working as expected, How to involve current Value?

Hi there,  as a newbie my situation looks quiet simple, but I am fully stuck. Tthere is a table with a userdefined column containing a duration: IntervalPlus = [MyTime]+ #duration(0,0,60,0) With t...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    or directly like:

    Column =
    VAR _time = ExData[Time]
    RETURN
    SUMX(
        FILTER(
           ExData,
           ExData[Time]>=_time
       &&ExData[Time]<=_time+1/24/6
         ),
        ExData[Value]
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

could you tell us more about your expectation the measure, like what do you mean by "predictive graph"?