Selecting the 2nd Most Recent value for the Transaction list

Hello @Dastan ,

I hope someone else in the community has a better answer that the one coming up as it is a bit convoluted, but it should lead you to what you are after.

1. You are going to create a RANK - information here - in the Dates to evaluate when is your 2nd most recent event.
   • The formula could be something akin of the following:

   • rank(Transaction list name.'Date',Transaction list name.'Product Dimension',asc,sequential)

2. Create a new dimension with two items manually input. Name them 1 and 2
3. Create a new property in the transactional list where you are going to use the ITEM function - information here - to map your Rank with the dimension you just created.
   • The formula could be something akin of the following:

   • item(text(Transactional list name.Rank), '1-2'.Name)

4. Build your target metric dimensioned by Product and formatted as Date.
5. Apply the following formula:

   • 'Transactional list name'.'Date'[by first: 'Transactional list name'.'Product', 'Transactional list name'.'1-2'][filter: '1-2'='1-2'."2"][remove firstnonblank: '1-2']

That should resolve in the dates that you are after. I hope it makes sense and, as I said, that someone provides an easier answer.

Cheers!

Thank you guys. It worked. But now, I have follow-up question:

How can I use ranking numbers to bring the subsequent row’s date value into the column next to the ranked column? Here:

Nevermind, actually I was able to do it with the use of Ranking Dimension, creating metrics, and using SELECT: Ranks-1