Forum Discussion
Get next value using something like EARLIER
HI, at the moment im using this
previousdata =
VAR _id =Query1[setDataId]
VAR prevDate =
CALCULATE (
MAX ( Query1[_startedAt]),
FILTER ( ALL ( Query1 ), [_startedAt] <= EARLIER ( Query1[_startedAt] ) && Query1[setDataId] = _id )
)
RETURN
LOOKUPVALUE ( Query1[HoraInt], Query1[_startedAt], prevDate )
WIth this formula im getting the previous value of (Query1[HoraInt]) with the same id and that happens previoulsy
I want something similar by with the value that happens NEXT
Is there a formula?
Thanks
Try this:
As a calculated column:
c_Column = CALCULATE(MIN('Table 2'[Value]), FILTER('Table 2', 'Table 2'[Value] > EARLIER('Table 2'[Value])))
2 Replies
Try this:
As a calculated column:
c_Column = CALCULATE(MIN('Table 2'[Value]), FILTER('Table 2', 'Table 2'[Value] > EARLIER('Table 2'[Value])))