Slice from a table with date column, I would ...

(Mikko Palmu) #1

Slice from a table with date column, I would like the slice to show next 10 rows in the future, how do I do that? [Date]>=TODAY() and then +10 to [_RowNumber], but how do I find the 1st row in the future?

(Aleksi Alkio) #2

You would need to find the first rownumber where the [Date]=TODAY() and then show the rest.

(Mikko Palmu) #3

there’s probably no rows with todays date, first is somewhere in the future. I tried nesting Select functions to first find the min of dates bigger than today, but it gives error “Select has invalid inputs”

[_RowNumber] = any(select(list([_RowNumber]), [Date]=min(select(list([Date]), [Date]>today()))))

(Bellave Jayaram) #4

You could try:

[_RowNumber] = MIN(select(TblName[_RowNumber], [Date]>today()))

(Mikko Palmu) #5

@Bellave_Jayaram thanks, that looks better!

(Mikko Palmu) #6

For some reason the result of +10 expression changes depending on the location of +10, see below… Doesn’t make sense to me, even with parentheses around the MIN function

correct location

(Mikko Palmu) #7

and wrong