Comparing Power BI Licenses
The Power BI licenses you use have 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 extract dates from text values in Power Query. You may work with integers or text values that represent dates. For …
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)
List functions in Power Query are often used for data transformations. You commonly find lists of numbers, letters, times, dates etc. And these lists are …
Create Date Table or Calendar in Power Query M | with Free 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 …