Roman - I would like to see your work book but the approach I would take would be to use Lookup([measure],1) It would need to be included in an if statement that identifies the record with the "Certain Date"
If you supply your TWBX workbook with the data included and how you determine the 'certain date' I could be more specific
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Interesting Stuff..Let's see some dummy data.
Hi Jim, Unfortunately, I can not provide workbook due to Data Protection.
The scenario is that buyer opened account say on 01.01.2017 then he made few purchases on 02.03.2017, 05.06.2017, 09.10.2017, 21.12.2017, 28.01.2018 and 15.03.2018. On 11.11.2017 there was some details change (And I need first purchase date after this date which is 21.12.2017).