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 in Category ‘Power BI’
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
Import text from pdf files in Power BI
While Power BI will soon provide functions to import tables from pdf-files, there might be occasions when you actually need to import text from pdf files (in unstructured form). With a little help from R (…) 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
DAX evaluation context indicator with syntax highlighting
This is a post about a feature request, that definitely would make my life easier (and I guess others’ too): Evaluation context and its transition is one of the hardest (…) Read more