Power Query

Power Query · 19. März 2023

Thinking Power Query - M data structures and a not so simple challenge

An introduction to M data structures and how understanding these structures helps to apply more complex transformations to your data.

Power Query · 29. Mai 2022

Retrieve values from remote tables inside a query step (anonymous function / inline function)

Power Query · 02. Juni 2021

Using Power Query for Data Sampling

The other day I was facing an interesting question "How can I randomly draw ten records from the top 50 for each group using Power Query?" As you may guess, this article also contains the answer.

Power Query · 18. Januar 2021

Events and projections, using M

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Power Query · 27. Juli 2018

Using Power Query to convert an ip4 address into a numeric value

Using a custom function in Power Query M to convert an ip4 address into a numeric value, with the help of List.Accumulate