Expression to filter a slice

Hi,

I want to create a slice based on some specific row-column. I have a table with columns - Invoice Date, Start Date and End Date. I want to filter data based on the value of Row # 2 of Column Start Date and End Date. How can I refer to this specific Row and column in my filter expression?

Thank you very much.

1 Like

Maybe this:

ANY( SELECT(
  table[column] ,
  [_RowNumber] = 2
) )
3 Likes

Thank you very much. This is the expression I was looking for.

1 Like