Power Query M equivalent of Excel PV formula

[mike.magill]

Excel has a very useful formula, PV, for calculating the present value of a constant stream of future cashflows. I can't find an equivalent method using M in Power Query. Can anyone help?

 

[alansidman]

I don't believe that there is an M calculation. You would need to create an algebraic formula in a column. You could do it in DAX if you were working in Power BI instead of Power Query. Most of the skills in PQ are rearrangement of data with basic calculations.