Skip to content

BI Gorilla

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

Power Query

Post Image - Aggregate Text Values

Aggregate Text Values Using Group By in Power Query

2nd January 20212nd January 2021 by Rick de Groot Categories Power Query

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

Read moreAggregate Text Values Using Group By in Power Query

Categories Power Query
If function in Power Query - Featured Image

The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)

2nd January 202113th July 2020 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 moreThe IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)

Categories Power Query
Featured Image - Sum Null Values in PowerQuery

3 Ways to SUM null values in Power Query

2nd January 20218th June 2020 by Rick de Groot Categories Power Query

Getting unexpected results when summing up null values in Power Query is something beginners bump into all the time. And the reason for this is …

Read more3 Ways to SUM null values in Power Query

Categories Power Query
Page Image - Change Column Type By Position

Change Column Type By Position in Power Query

13th January 20212nd November 2018 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 moreChange Column Type By Position in Power Query

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 20204th October 2018 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 moreFix Error When Reading XLSB File in Power Query

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

Define Data Type While Creating Custom Column in Power Query

2nd January 20216th August 2018 by Rick de Groot Categories Power Query

When working with Power Query, it is easy to end up with many applied steps. And the more applied steps your query includes, the more …

Read moreDefine Data Type While Creating Custom Column in Power Query

Categories Power Query
Page Image - Split Column By Carriage Return

Split Column by Carriage Return in Power Query

21st June 202013th July 2018 by Rick de Groot Categories Power Query

Scraping content from the web is getting easier and easier. Sometimes for the data to be useful you need to break the data up into …

Read moreSplit Column by Carriage Return in Power Query

Categories Power Query
Featured Image - Create all unique combinations

2 Tricks to Create Unique Combinations From Multiple Columns in Power Query

2nd January 202131st May 2018 by Rick de Groot Categories Power Query

There are times where you need an efficient way to produce all unique combinations of your data. Recently a customer of mine used a report …

Read more2 Tricks to Create Unique Combinations From Multiple Columns in Power Query

Categories Power Query
Page Image - 2 ways to Rank with Ties

2 Ways to Rank With Ties Using Power Query

21st June 202025th May 2018 by Rick de Groot Categories Power Query

Recently I worked on a challenge from Ken Puls, where I needed to figure out how to Rank With Ties. Ken had a set of …

Read more2 Ways to Rank With Ties Using Power Query

Categories Power Query
Page Image - Transform Stack Column Into A Table

Transform Stacked Column into a Table with Power Query

21st June 202018th May 2018 by Rick de Groot Categories Power Query

Data comes in countless ways and forms. Sometimes structured, with an SQL database, a table in Excel or several CVS files. The fun with Power …

Read moreTransform Stacked Column into a Table with Power Query

Categories Power Query
Post navigation
Older posts
Page1 Page2 Next →

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

  • Aggregate Text Values Using Group By in Power Query
  • How to use Conditional Formatting based on a Measure in Power BI
  • Optimizing the performance of DISTINCTCOUNT in DAX
  • The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
  • 7 Ways to Open Multiple Instances of Excel

Tags

Add Column Array Break-line Calendar Carriage Return Column Type Concatenate Conditional Formatting conditional if-statement Cube Formula CUBEMEMBER CUBEVALUE Custom Column Custom Format Data Model Data Type Date DAX Error Message Formatting Function Get and Transform Group By Index ISNUMBER List MATCH Modulo New Instance Paste Special Pivot Pivot Table Power Pivot Rank ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Group Table.Max Ties XLSB

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

  • Aggregate Text Values Using Group By in Power Query
  • How to use Conditional Formatting based on a Measure in Power BI
  • Optimizing the performance of DISTINCTCOUNT in DAX
  • The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
  • 7 Ways to Open Multiple Instances of Excel

TOPICS

Add Column Array Break-line Calendar Carriage Return Column Type Concatenate Conditional Formatting conditional if-statement Cube Formula CUBEMEMBER CUBEVALUE Custom Column Custom Format Data Model Data Type Date DAX Error Message Formatting Function Get and Transform Group By Index ISNUMBER List MATCH Modulo New Instance Paste Special Pivot Pivot Table Power Pivot Rank ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Group Table.Max Ties XLSB

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© Copyright 2018 - 2021 | BI Gorilla | All Rights Reserved
Terms | Privacy | Contact