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 …
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 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 is powerful function that allows you to create lists of values based on logic. This can be a list with text or numbers, but …
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 are often used for data transformations. You commonly find lists of numbers, letters, times, dates etc. And these lists are useful …
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 …
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 …
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 …
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 …
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 …