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
While Power Query provides a convenient method to fill values from selected columns up- and downwards, there is no native option to do this to the right or left. So this article provides a custom function to do so. Table.FillRight in Power Query https://gist.github.com/ImkeF/d2031e6f6f401f22703334166cf1cae7 Usage to fill values to the right (or left) in Power … Read more