Simple multi row formula

Hamder83

Hi 

I am loading all customers agreements into my flow.

Lets say one customer gets a new agreement every year.

Then every time i load a new agreement, I want to set end date of the previous agreement to the start date of the new.

ive attached sample data, and how I filled my muti row forumla, but I am missing something...

Thanks in advance,

SampleData MultiRow.xlsx

atcodedog05

Hi @Hamder83 

Here is how you can do it.

Workflow:

1. Using sort tool sort by customer, sort start date by descending.

2. Using multi-row formula groupby customer and take previous row start date.

Hope this helps : )

AgreementEndDate.yxmd