BI Gorilla • Advance with Excel and Power BI

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