Calculating PV referencing different columns and tables

Hi all,

Firstly, thank you so much for looking at my query today.

I am trying to calculate PV for my table. At the moment I am using a dax measure but ideally I would like to achieve this in Power Query if possible...Can you please help me action the PV formula as shown below:

I am trying to achieve the "PV Column" as shown in the above Table 1.

Could someone please show me how to do this in either Power Query or DAX?

Thank you once again,

Edward