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 ‘Excel’
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
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
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
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more
How to import from Excel with cell coordinates in Power Query and Power BI
There might be occasions where you want to import data from Excel into Power Query or Power BI using cell coordinates like a range from E3 until G9 for example (…) Read more