List.Accumulate in Power Query (Explained with Examples)
List.Accumulate is a one of the more complex Power Query functions that is not well understood. It allows you to perform an action repeatedly and …
Create Date Table with Dynamic Language in Power Query
The Date table is an essential piece of every data model. And when you work with different users, some users look for one in English …
Creating Tables in Power Query M (40+ Examples)
Tables have a fundamental place in Power Query. Most transformations you make are based on tables and mastering how they work helps you in your …
Comparing Licenses in Power BI
The Power BI license you use has a big impact on which features are available to you. To get started a basic user a Free …
Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
In this post you learn how to create ordinal numbers in both DAX and M. An Ordinal Number is a number that tells the position of something, such as …
How to Extract Dates From Text String in Power Query
This post shows how to transform a text string into a date in Power Query. You may work with integers or text values that represent …
Text Functions in Power Query M (150+ Examples)
Text functions are foundational in your Power Query journey. They allow you to analyze and manipulate text values. And once you master them you will …
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 …
