When working with cloud data sources you might encounter links where spaces show up as “%20” instead for example. This is called URI escaping or encoding. In Power Query there is a native function that does this kind of encoding: Uri.EscapeDataString – PowerQuery M | Microsoft Learn However, a native function that does just the … Read more
When you reference another query in Power Query you will automatically get the results of the final step. But what if you want to reference a step that sits within that referenced query? One solution would be to split up that query into 2 and reference the final result of the splitted query. But that … Read more
While Excel and DAX have native functions to calculate the payment amount for a loan, Power Query lacks it still. As this is a very useful function, it’s time to create our own Payment function (PMT) for Power Query: Excel’s payment function (PMT) for Power Query Excel’s PMT function returns the payment for a loan … Read more
While Excel and DAX have native functions to calculate the future value of a payment series, Power Query lacks it still. So it’s time to create our own function for the Future Value (FV) for Power Query: Excel’s function for the Present Value (FV) for Power Query Excel’s FV function returns the future value of … Read more
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: Excel’s Present Value (PV) function for … Read more
Formula.Firewall issues can hit you when designing your queries or even “out of the blue” when suddenly refreshes in the service are failing due to changes in the query evaluation. You will find a lot of methods published on the internet which are good and cover different scenarios. But there is also a very quick … Read more