When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the address for the next page. You (…) Read more
Posts in Category ‘Function’
Date.Networkdays function for Power Query and Power BI
Today I’m going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function’s first 3 parameters work (…) Read more
Advanced transformations on multiple columns at once in Power BI and Power Query
You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more
Dynamically create types from text with Type.FromText in Power Query and Power BI
In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more
Text.RemoveBetweenDelimiters function for Power BI and Power Query
While Power Query has a native function to fetch text between 2 delimiters in Power Query, there is no such function that removes the text instead. Therefore I’ve created a (…) Read more