Skip to content

BI Gorilla

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

Function

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

Optimizing the performance of DISTINCTCOUNT in DAX

19th October 202014th August 2020 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 moreOptimizing the performance of DISTINCTCOUNT in DAX

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

SUMPRODUCT with Multiple OR Criteria – Part 2/2

21st June 202022nd July 2019 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 moreSUMPRODUCT with Multiple OR Criteria – Part 2/2

Categories Excel
Featured-Image- Excel-Cube-Functions

An Intro to Cube Functions for Power Pivot in Excel

21st July 20204th June 2019 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 moreAn Intro to Cube Functions for Power Pivot in Excel

Categories Excel
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
Featured Image - SUMPRODUCT Multiple AND Criteria

How to Use SUMPRODUCT With Multiple AND Criteria

18th July 202015th June 2018 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 moreHow to Use SUMPRODUCT With Multiple AND Criteria

Categories Excel
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

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