In the first post of this series I’ve explained how to simultaneously load and combine multiple (similar structured) tables from ONE PAGE. This post handles the other direction, how to combine tables (…) Read more
All Posts by Admin
A generic SWITCH-function for the query editor in Power BI and Power Query
Although you can easily replicate the DAX SWITCH-function via list-, table- or record functions in M, I thought it would be convenient for many newbies to have a comfortable M-SWITCH-function that (…) Read more
Web Scraping 1: Combine multiple tables from one page in Power BI and Power Query
This is a step-by-step description of how to combine multiple tables from one webpage into one table with categories as output. You can also apply this technique to combine tables from (…) Read more
List.SelectPositions in Power BI and Power Query
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
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