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