With this new custom function “List.SelectPositions” you can easily select items from a list by just passing a list of their positions within it as the parameter. What it does Say (…) Read more
Posts Tagged ‘Power Query’
Table.Group: Exploring the 5th element in Power BI and Power Query
In this post I’ll show you the magic stuff you can do with the 5th parameter (the optional comparer function) of the Table.Group M-function in Power BI and Power Query: Table.Group parameters (…) Read more
Remove repeating characters from a string in Power BI and Power Query
Repeating spaces often cause problems when cleaning up your data. My new function “Text.RemoveRepeatingCharacters” can come to the rescue here. Imagine you have a table like this: Challenge To further work with this (…) Read more
Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query
Today I’m sharing a handy function with you that allows you to retrieve all or just a couple of dates between 2 given dates: Date.DatesBetween. Usage This function takes 3 (…) Read more
Create a function library in Power BI using M-Extensions
Having the ability to use own M-function the same way than native functions in Power BI and Excel has been one of my biggest wishes for quite some time. So I (…) Read more
How Power Query can return clickable hyperlinks with friendly names to Excel
When you use Power Query as an Excel-automation-tool rather than just to feed the data model, you might want to return clickable hyperlinks that carry friendly names. This doesn’t work out of (…) Read more