Calculating PV referencing different columns and tables

[edwardroa]

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

[v-easonf-msft]

Hi, @edwardroa 

Please check if this thread could help.

https://community.powerbi.com/t5/Desktop/Try-to-calculate-PV-in-Dax-can-any-one-help/m-p/738813 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@edwardroa , I have dicussed that in this video -PMT, PV, FV, Rate,NPER -  https://youtu.be/9VYqbj2h4zE

[edwardroa]

Thanks Amit,

My question is more around referencing different columns from the same table and different table. Unsure how to do this?

Thanks,
Edward