How to extract the 2nd and 3rd date value from the table

s_kula — Tue, 31 Jan 2023 10:07:36 GMT

Hello, I need to find 2 date string value. I created a table that sorts the dates in descending order:

=RANKX(RELATEDTABLE('pz database'),'pz database'[TrE_DataDok];;DESC;Skip)

however, I don't know what function I can extract the 2nd and 3rd date value from the table.

Anyone able to help?

Re: How to extract the 2nd and 3rd date value from the table

FreemanZ — Tue, 31 Jan 2023 10:43:06 GMT

try like:

EXCEPT(

TOPN(3, ),

TOPN(1, )

)