Skip to content

BI Gorilla

  • Blog
  • Videos
  • Contact
  • About
BI Gorilla
  • Blog
  • Videos
  • Contact
  • About
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

How to use Conditional Formatting based on a Measure in Power BI

4th January 202127th October 2020 by Rick de Groot Categories Power BI

With conditional formatting in Power BI, you can apply formatting to your values based on conditions. For example, you can format a cell’s background based …

Read moreHow to use Conditional Formatting based on a Measure in Power BI

Categories Power BI

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
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
7 ways to open Multiple Instances of Excel - Featured Image

7 Ways to Open Multiple Instances of Excel

21st June 202016th June 2020 by Rick de Groot Categories Excel

When you work with multiple workbooks in Excel, you may sometimes experience issues. During a resource intensive task in one spreadsheet, other spreadsheets within the …

Read more7 Ways to Open Multiple Instances of Excel

Categories Excel

2 Awesome Tips on How to Use the SWITCH Function in Excel

2nd January 202111th June 2020 by Rick de Groot Categories Excel

The SWITCH Function is one of Excel’s logical functions that can function as an alternative to the conditional if-statements. Many excel users use if-statements to …

Read more2 Awesome Tips on How to Use the SWITCH Function in Excel

Categories Excel
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
Featured Image - How to Calculate Same Day Growth

How to Calculate Same Day Growth in Power BI

21st June 20205th June 2020 by Rick de Groot Categories Power BI

When doing analysis it important that numbers are comparable. After all, you want to know how a company performs. And these comparisons are not always …

Read moreHow to Calculate Same Day Growth in Power BI

Categories Power BI
Featured Image - Format Negative Numbers between Parentheses

How to Display Negative Numbers Between Parentheses in Power BI

2nd January 202125th May 2020 by Rick de Groot Categories Power BI

Formatting is key in financial reporting. It helps users consume the data in a pleasing way. One aspect that is often looked at in Balance …

Read moreHow to Display Negative Numbers Between Parentheses in Power BI

Categories Power BI
Featured Image - Add references to cells in bulk

Advanced Hack: Add References to Cells in Bulk

18th July 20206th August 2019 by Rick de Groot Categories Excel

There are times when you want a set of cells to reference a parameter. For example, you’re budgeting and the result needs to be dynamic. …

Read moreAdvanced Hack: Add References to Cells in Bulk

Categories Excel
Post navigation
Older posts
Page1 Page2 Page3 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