Skip to content

Gorilla BI

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

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

Pivot Text Values in Power Query – Explained

21st June 2022 by Rick de Groot Categories Power Query

The above video breaks down how you can pivot text values in Power Query. The regular pivoting of numbers is straight forward. But when text …

Read more

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

Replace Values in Power Query M (Ultimate Guide)

21st June 2022 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
Create journal entry with power query

How to create a Journal Entry with Power Query

21st June 2022 by Rick de Groot Categories Power Query

Create a journal entry using Power Query. In this post you learn how to create records, sum columns and combine datasets using Power Query. A …

Read more

Categories Power Query
Post Image - Aggregate Text Values

Using Group by to Concatenate Text in Power Query

21st June 2022 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
If function in power query

Mastering IF Statements in Power Query – Including Nested IF-Statements

21st June 2022 by Rick de Groot Categories Power Query

The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …

Read more

Categories Power Query
Featured Image - Sum Null Values in PowerQuery

3 Ways to SUM null values in Power Query M

21st June 2022 by Rick de Groot Categories Power Query

Trying to sum columns with null values in Power Query but getting unexpected results? It is something beginners bump into all the time. And the …

Read more

Categories Power Query
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
Page Image - Fix Error When Reading XLSB File In Power Query

Fix Error When Reading XLSB File in Power Query

21st June 2020 by Rick de Groot Categories Power Query

Recently one of my clients built a Power Query solution. In one of the steps, the query ran into an unknown error. The query started with …

Read more

Categories Power Query
Page Image - Define Data Type While Creating Custom Column

Define Data Type While Creating Custom Column in Power Query

21st June 2022 by Rick de Groot Categories Power Query

In this post you learn how to define a Data Type at the same moment as you add a custom column. By default, Power Query …

Read more

Categories Power Query
Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 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

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

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

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© 2022 Gorilla BI
Next Page »