You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more
Posts Tagged ‘Function’
Dynamically create types from text with Type.FromText in Power Query and Power BI
In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more
The full Table.ContainsAnywhere function for Power Query in Power BI and Excel
In a previous post I introduced the concept of a function that searches for an occurrence of a character or string within all columns of a table. Here I share (…) Read more
A new Table.ContainsAnywhere function for Power Query in Power BI and Excel
The native Table.Contains-function in Power Query tells you if one or more strings are included in one or more of its columns. But you have to be specific about which (…) Read more
Improved Text.SplitAny – function for Power BI and Power Query
Today I’ll present an adjustment to the Text.SplitAny – function in Power BI’s query editor or Power Query. The native function takes a string as an input and splits the (…) Read more
Fast and easy way to reference previous or next rows in Power Query or Power BI
When you search the web for solutions to reference previous or next rows in the query editor of Power BI or Power Query, you will find many solutions that base (…) Read more