List.Generate in Power Query: Tutorial with Easy Examples
List.Generate is powerful function that allows you to create lists of values based on logic. This can be a list with text or numbers, but …
Power Query
How to use List.Generate to make API Calls in Power Query M
The List.Generate function allows you to create a series of values based on logic. What makes List.Generate so powerful is that it can perform a …
Lists in Power Query M / List Functions (200+ Examples)
Lists in Power Query are often used for data transformations. You commonly find lists of numbers, letters, times, dates etc. And these lists are useful …
Create Date Table or Calendar in Power Query M | including Script
This post describes how to create a dynamic date table using Power Query. Virtually every Power BI solution benefits from a date table. The date …
Get Value from Previous Row using Power Query
In this post you learn how to get the previous row value using Power Query. This is a useful skill to compare previous row value …
3 Ways to Add Leading Zero to Number in Power Query
A leading zero is any 0 you add before the first nonzero digit of a string. By definition, these are invisible when a value has …
Pivot Text Values in Power Query – Explained
The above video breaks down how you can pivot text values in Power Query. The regular pivoting of numbers is straight forward. But when text …
Replace Values in Power Query M: tutorial, examples (Ultimate Guide)
Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …
How to create a Journal Entry with Power Query
Create a journal entry using Power Query. In this post you learn how to create records, sum columns and combine datasets using Power Query. A …
Using Group by to Concatenate Text in Power Query
Most users know the Group By functionality in Power Query. It allows you to summarize data and aggregate the grouped values. The standard aggregations are …
