Forum Discussion
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...
or directly like:
Column =VAR _time = ExData[Time]RETURNSUMX(FILTER(ExData,ExData[Time]>=_time&&ExData[Time]<=_time+1/24/6),ExData[Value])
FreemanZ
Super User
Super Userhi Anonymous
try like:
Column =
SUMX(
FILTER(
ExData,
ExData[Time]>=EARLIER(ExData[Time])
&&ExData[Time]<=[IntervalPlus]
),
ExData[Value]
)
FreemanZSuper User
Super Useror directly like:
Column =
VAR _time = ExData[Time]
RETURN
SUMX(
FILTER(
ExData,
ExData[Time]>=_time
&&ExData[Time]<=_time+1/24/6
),
ExData[Value]
)
Well, this works great, thank you very much. It is not easy for me to get into this, as it is more or less a side quest. Thanks a lot