Divide previous row by next row

Hi All,

In continutation of the above calculation: I have another query which refers to the same. I need to derive a different kind of solution that needs to be worked upon:

E.g. below: I want to know whether this solution is achieveable through powerbi

What I need to achive is:

The above table is derived from the below calculation: I need to consider max date (which would be every date for every Keyword

SO based on the Max Actual Search Volume: The Search volume will be Divided by the KeyWord of the same day: For. e.g.  03-05-2020: So 537580.07 / 91 = 5907.47. This value that is derived will then be Multiplied by the previous years Keyword to get the previous year's Actual search volume: So when we multiply 5907.47 to 54 which is the volume on 03-05-2018 ; I get the value as 319003.3. I need to achieve this in dynamically for all keywords.

Excel file is stored here: https://drive.google.com/file/d/1QZQzmyQmXSGpZF_R8MUsorrO36AIF8pT/view?usp=sharing 

But the only thing here is: The current year should have the actual value where-as the previous years will have the calculated value in a same column. Is this achieveable in PowerBI?

Regards,

PrathSable