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 …
List
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 …
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 …
