Power Query M equivalent of Excel PV formula

mike.magill

New member
Joined
Jan 24, 2017
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2016
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?
 
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.
 
Back
Top