The IN Operator in M / Power Query
When creating conditional if statements, a common requirement is to check if a value equals one of many. In most programming languages you can find …
When creating conditional if statements, a common requirement is to check if a value equals one of many. In most programming languages you can find …
When performing calculations in Power Query, a common requirement is to provide a default value instead of null. One way to approach this is by …
Transforming multiple columns at once can save you a lot of manual work. This is particularly useful when you want to apply the same transformation …
I love adding a last refresh date and time to reports. This gives the user an indication of how recent your dataset retrieved data 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 …