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?
You would need to find the first rownumber where the [Date]=TODAY() and then show the rest.
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()))))
You could try:
[_RowNumber] = MIN(select(TblName[_RowNumber], [Date]>today()))
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