cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lrozan Frequent Visitor
Frequent Visitor

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
hnguy71 Member
Member

Re: Get next value using something like EARLIER

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 2
Highlighted
hnguy71 Member
Member

Re: Get next value using something like EARLIER

Try this:

As a calculated column:

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

Re: Get next value using something like EARLIER

Perfect, it works fine ! thanks