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