Get next value using something like EARLIER

[Anonymous]

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

[hnguy71 · Accepted solution]

Try this:

As a calculated column:

c_Column = CALCULATE(MIN('Table 2'[Value]), FILTER('Table 2', 'Table 2'[Value] > EARLIER('Table 2'[Value])))

[Anonymous]

Perfect, it works fine ! thanks