Skip to content

BI Gorilla

  • Blog
  • Videos
  • Contact
  • About
BI Gorilla
  • Blog
  • Videos
  • Contact
  • About

The IN Operator in M / Power Query

16th August 2022 by Rick de Groot Categories 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 …

Read more

Categories Power Query

The COALESCE Operator in M / Power Query

9th August 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query
Rename Columns in Bulk in Power Query featured image

Transform Column Names in Bulk in Power Query

28th July 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query

Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)

20th July 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query

List.Accumulate in Power Query (Explained with Examples)

26th July 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query

Create Date Table with Dynamic Language in Power Query

10th July 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query

Creating Tables in Power Query M (40+ Examples)

5th August 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query
Power-BI-Comparing-Licenses

Comparing Licenses in Power BI

3rd May 2022 by Rick de Groot Categories Power BI

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 …

Read more

Categories Power BI
DAX Ordinal Numbers Result

Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

5th July 2022 by Rick de Groot Categories 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 …

Read more

Categories Power BI
Extract Date From Text in Power Query

How to Extract Dates From Text String in Power Query

24th July 2022 by Rick de Groot Categories 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 …

Read more

Categories Power Query
Post navigation
Older posts
Page1 Page2 … Page5 Next →
+ More

Stay in the Loop

Get the latest Excel and BI advice, tips and in-depth tutorials delivered straight to your inbox.

Microsoft MVP:

Subscribe to my Channel

Youtube subscribe button

Want Some Help

As well as being a blogger, I’m an independent consultant with a passion for Excel and Power BI. I have background in Finance and work with customers to find business solutions that increase insight and quicken decision making. I’d be happy to work on interim assignments.

For more details see:

Linkedin Image

Recent Posts

  • The IN Operator in M / Power Query
  • The COALESCE Operator in M / Power Query
  • Transform Column Names in Bulk in Power Query
  • Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)
  • List.Accumulate in Power Query (Explained with Examples)

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date Table DateTime.LocalNow Function Group By List List.Combine List.Contains List.Dates List.Distinct List.Generate List.MinN List.Numbers List.PositionOf List.Range List.RemoveFirstN List.RemoveItems List.RemoveMatchingItems List.RemoveNulls List.ReplaceMatchingItems List.Sum List.Union Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart

Categories

  • DAX
  • Excel
  • Power BI
  • Power Query

About BI Gorilla®

BI Gorilla is a free resource site for Excel and Power BI enthusiasts. BI Gorilla was founded in 2018 by Rick de Groot. The main goal of this site is to provide quality tips, tricks, hacks, and other resources that help you advance with Power BI and Excel.

RECENT POSTS

  • The IN Operator in M / Power Query
  • The COALESCE Operator in M / Power Query
  • Transform Column Names in Bulk in Power Query
  • Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)
  • List.Accumulate in Power Query (Explained with Examples)

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date Table DateTime.LocalNow Function Group By List List.Combine List.Contains List.Dates List.Distinct List.Generate List.MinN List.Numbers List.PositionOf List.Range List.RemoveFirstN List.RemoveItems List.RemoveMatchingItems List.RemoveNulls List.ReplaceMatchingItems List.Sum List.Union Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart

SOCIAL

  • YouTube
  • LinkedIn
  • Twitter

© 2022 BI Gorilla
Next Page »