Skip to content

Gorilla BI

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

Power BI

Power-BI-Comparing-Licenses

Comparing Licenses in Power BI

3rd May 2022 by Rick de Groot Categories Power BI

The Power BI license you use has a big impact on which features are available to you. To get started a basic user a Free …

Read more

Categories Power BI

Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

19th April 2022 by Rick de Groot Categories Power BI

In this post you learn how to create ordinal numbers in both DAX and M. An Ordinal Number is a number that tells the position of something, such as …

Read more

Categories Power BI
Set Default Slicer Selection to Current Year or Month

Set Default Slicer Value to Current Month in Power BI

6th October 2021 by Rick de Groot Categories Power BI

You have a report and want to show a default slicer value that moves with time. When you arrive at the next month, you want …

Read more

Categories Power BI

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

4th January 2021 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 more

Categories Power BI
Featured Image - How to Calculate Same Day Growth

How to Calculate Same Day Growth in Power BI

21st 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 more

Categories Power BI
Featured Image - Format Negative Numbers between Parentheses

How to Display Negative Numbers Between Parentheses in Power BI

2nd January 2021 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 more

Categories Power BI

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

  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
  • How to Extract Dates From Text String in Power Query
  • Text Functions in Power Query M (150+ Examples)
  • List.Generate in Power Query: Tutorial with Easy Examples

Tags

Array Break-line Calendar Carriage Return Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Formatting Function Group By List List.Contains List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX SWITCH Table.Max Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Ties

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

  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
  • How to Extract Dates From Text String in Power Query
  • Text Functions in Power Query M (150+ Examples)
  • List.Generate in Power Query: Tutorial with Easy Examples

TOPICS

Array Break-line Calendar Carriage Return Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Formatting Function Group By List List.Contains List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX SWITCH Table.Max Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Ties

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© 2022 Gorilla BI