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[_s...
Try this:
As a calculated column:
c_Column = CALCULATE(MIN('Table 2'[Value]), FILTER('Table 2', 'Table 2'[Value] > EARLIER('Table 2'[Value])))
Try this:
As a calculated column:
c_Column = CALCULATE(MIN('Table 2'[Value]), FILTER('Table 2', 'Table 2'[Value] > EARLIER('Table 2'[Value])))Perfect, it works fine ! thanks