Solved: Need to slice table to return first false - Page 2

Vjmiyagi · 03-07-2024 01:17 PM

I have a table with TV series, season, episodes, titles, and whether watched or not. I would like to write a filter that gives me the 1st not watched episode in a series. I have tried:

TOP(FILTER(Shows,[Watched] <> true),1)

and get the error The expression is valid but its result type 'List' is not one of the expected types: Yes/No

Thank you in advance for any help you can help.

Suvrutt_Gurjar

Hi ,

By [key column], it means whatever column is marked as key column in your " Shows" table.

It sounds that [ID] is key column on your table. If so please try an expression of

[ID] = MINROW("Shows","_ROWNUMBER",AND([Series]=[_THISROW].[Series],[Season]=[_THISROW].[Season],NOT([Watched])))

I am replying from mobile, so coukd not properly see the table image shared by you.

View solution in original post