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 …
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 …
Set Default Slicer Value to Current Month in Power BI
You have a report and want to show a default slicer value that moves with time. When you arrive at the next month, you want …
3 Ways to Add Leading Zeros to Numbers 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 (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 …
