need help with dax to generate two columns from and to dates in the below table

[Truelearner]

i want to create from and TO columns based on the effective date i have , From column is same as the effective date but To column is one day less than next effective date . Below is the sample data 

@mgwena @cham @amitchandak @Greg_Deckler @Mariusz 

base curr	exchange curr	effective date	rate	From	TO
usd	INR	dec-31-2019	70.23	dec-31-2019	jan-30-2020
usd	INR	jan-31-2020	70	jan-31-2020	feb-28-2020
usd	INR	feb-29-2020	71	feb-29-2020	mar-15-2020
usd	INR	mar-16-2020	72	mar-16-2020	apr-27-2020
usd	INR	apr-28-2020	73	apr-28-2020	may-30-2020

[amitchandak · Accepted solution]

Try new columns like

from =table[effective date]
to = minx(filter(table, table[base curr] =earlier[base curr] && table[exchange  curr] =earlier[exchange  curr]
							&& table[effective date] >earlier[effective date]),table[effective date])-1