power query

Scenario: Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.   Sample data: Expected ...

I decided to stop writing book reviews here on my blog a long time ago: it’s a lot of work to read a book and write a proper, detailed review and what’s more I don’t like the idea…

What is the Pivot Columns operation in Power Query? And how can you use it to pivot text values and numbers? Follow along to find out!

Replace values in Power Query is easy. Things get more complicated once you add conditions, on multiple columns, needed case-insensitive...

Learn how to add leading zero in Power BI using Power Query with a very simple step. You will have options to use other formats too.

Did you know that you can easily zoom in and out in the #PowerQuery window? Zoom in: CTRL+SHIFT+= Zoom out: CTRL+SHIFT+- Credit to https://lnkd.in/dt-qUqYD... 19 comments on LinkedIn

learn how to transform a status log table with one date column to a from and to date column based table using Power Query in Power BI.

Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with no item…

Learn how to create a dynamic date table in Power Query. Make sure to pick up your free script to generate a reusable calendar.

This article shows how to get the previous row value using Power Query. You can adjust the 3 ways to also retrieve an earlier or later row.

Here is a tip that reduces your Power Query steps with 1 step less. When I build date tables I typically use the function List.Dates to create a list of dates. As I want it as a table I use the Rib…

Learn about new Power Query-related updates in the recent October 2021 release of Power BI Desktop!

There’s a nice new feature in Power Query Online (the version of Power Query used in Dataflows): parameters of type List. You can see this as a new option in the Type dropdown in the “M…

How, when and why to use recursive functions within Power BI / Power Query. Theoretical and practical examples

Understanding the main principles of Parameters and Functions in Power Query and Power BI when it comes to Data Preparation and the M language.

An article that covers how in depth how the Combine Files experience in Power BI / Power Query and how parameters and functions work inside of it.

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

This article discusses how to create a custom functions in Power BI using Power Query. The latest SQL Server articles from SQLServerCentral

There are over 600 functions in Power Query. Yet, those functions won't always do what we need, therefore we might need to turn to custom functions.