I have a set of Pricing Data, see attached for sample. Where I have a record for every price per the effective date. I want to know how long since the most recent effective date an asset has been that price. Which I accomplished using Multi-row formula. For example the price on 4/29/22 was 99.718 and it has been that price since 3/30/22. I want to be able to ignore all the records before 3/30/22 and do a summary like this (for all assets - this is just 1). I am not sure if I need another multi-row formula to indicate a Y/N of 'most recent price indicator' so I can ignore the rest and get my min/max date or if some other tool(s) would be better. I will be working with millions of rows so efficient processing would be preferred. Thanks in advance for any help/advice!
Desired Summary for Asset ID/Current Price
| PRIMARY_ASSET_ID | SECURITY_PRICE_AMT | Days at Price | EFFECTIVE_DT | First_DT_of_Current _price |
| 1234 | 99.718 | 21 | 4/29/2022 | 3/30/2022 |
