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

[Mikko_Palmu]

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]

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

[Mikko_Palmu]

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]

You could try:

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

[Mikko_Palmu]

@Bellave_Jayaram thanks, that looks better!

[Mikko_Palmu]

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]

and wrong