Skip to content

Gorilla BI

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

Function

Text Functions in Power Query

Text Functions in Power Query M (150+ Examples)

25th May 2022 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query
Thumbnail leading zeros before numbers

3 Ways to Add Leading Zeros to Numbers in Power Query

30th November 2021 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query
Featured Image - Conditionally Replace values in Power Query

Replace Values in Power Query M (Ultimate Guide)

12th December 2021 by Rick de Groot Categories Power Query

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 …

Read more

Categories Power Query
Post Image - Aggregate Text Values

Using Group by to Concatenate Text in Power Query

23rd November 2021 by Rick de Groot Categories Power Query

Most users know the Group By functionality in Power Query. It allows you to summarize data and aggregate the grouped values. The standard aggregations are …

Read more

Categories Power Query

Optimizing the performance of DISTINCTCOUNT in DAX

9th May 2021 by Rick de Groot Categories DAX

A common operation in Power BI is calculating the Distinct Count of a column. You may, for example, want to show the number of unique …

Read more

Categories DAX
Featured Image - Sumproduct Multiple OR Criteria Part 2 - Final

SUMPRODUCT with Multiple OR Criteria – Part 2/2

21st June 2020 by Rick de Groot Categories Excel

In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …

Read more

Categories Excel
Featured-Image- Excel-Cube-Functions

An Intro to Cube Functions for Power Pivot in Excel

21st July 2020 by Rick de Groot Categories Excel

In an earlier post I wrote about the advantages of using the Data Model in Power Pivot. Not only does it save you time by …

Read more

Categories Excel
Page Image - Change Column Type By Position

Change Column Type By Position in Power Query

31st October 2021 by Rick de Groot Categories Power Query

Introduction As Power Query beginner, it is comfortable to use the user-interface to change your column names. It’s easy and quick. You double click a …

Read more

Categories Power Query
Featured Image - SUMPRODUCT Multiple AND Criteria

How to Use SUMPRODUCT With Multiple AND Criteria

18th July 2020 by Rick de Groot Categories Excel

There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …

Read more

Categories Excel
Page Image - Beginner Guide How to Use the SUMPRODUCT Function

Beginners Guide: How to Use the SUMPRODUCT Function in Excel

2nd January 2021 by Rick de Groot Categories Excel

SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …

Read more

Categories Excel
Post navigation
Older posts
Page1 Page2 Next →
+ More

Stay in the Loop

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

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

  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
  • How to Extract Dates From Text String in Power Query
  • Text Functions in Power Query M (150+ Examples)
  • List.Generate in Power Query: Tutorial with Easy Examples

Tags

Array Break-line Calendar Carriage Return Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Formatting Function Group By List List.Contains List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX SWITCH Table.Max Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Ties

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

  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
  • How to Extract Dates From Text String in Power Query
  • Text Functions in Power Query M (150+ Examples)
  • List.Generate in Power Query: Tutorial with Easy Examples

TOPICS

Array Break-line Calendar Carriage Return Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Formatting Function Group By List List.Contains List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX SWITCH Table.Max Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Ties

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© 2022 Gorilla BI
Next Page »