Skip to content

BI Gorilla

  • Blog
  • Videos
  • Contact
  • About
BI Gorilla
  • Blog
  • Videos
  • Contact
  • About
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
Essentials for Creating a Calendar - 0 Featured Image

Essentials for Creating a Calendar with Power Query

2nd January 20217th May 2018 by Rick de Groot Categories Power Query

A calendar table is often a requirement to make a proper analysis. Whether you are trying to show year-to-date positions, moving averages, or are dealing …

Read moreEssentials for Creating a Calendar with Power Query

Categories Power Query
Page Image - Group by Maximum Value Using Table.Max

How to Group By Maximum Value using Table.Max – Power Query

21st June 20202nd May 2018 by Rick de Groot Categories Power Query

In an earlier article, I showed a basic example of how to group data. The grouping functionality takes your data, let’s you perform some operations with …

Read moreHow to Group By Maximum Value using Table.Max – Power Query

Categories Power Query
Page Image - How to Group or Summarize Data

How to Group or Summarize Data – Power Query

2nd January 202127th April 2018 by Rick de Groot Categories Power Query

Many times, Excel users need to show their data in a summarized way. Go-to tools for many are PivotTables or formulas as SUMIFS, SUMPRODUCT, AGGREGATE …

Read moreHow to Group or Summarize Data – Power Query

Categories Power Query
Page Image - Import Multiple Files from a Folder

Import Multiple Files from a Folder with Power Query

18th July 202023rd April 2018 by Rick de Groot Categories Power Query

In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a …

Read moreImport Multiple Files from a Folder with Power Query

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

Beginners Guide: How to Use the SUMPRODUCT Function in Excel

2nd January 202112th April 2018 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 moreBeginners Guide: How to Use the SUMPRODUCT Function in Excel

Categories Excel
Excel - How to Round A number To Nearest 1000 - 0. Featured Image

How to ROUND a Number to the Nearest 1000

21st June 202027th March 2018 by Rick de Groot Categories Excel

Financial reports can sometimes be very messy to look at. Whereas consumers want to understand the big picture, sometimes the numbers are so detailed, they …

Read moreHow to ROUND a Number to the Nearest 1000

Categories Excel
Post navigation
Newer posts
← Previous Page1 Page2 Page3

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