Press "Enter" to skip to content

Calculating Present Value in Power Query

Imke Feldmann has a function for us:

Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s start collecting some fodder for it, by creating a function to calculate the Present Value (PV) for Power Query:

Click through for that function, as well as an explanation of what it’s doing.