Skip to content

Gorilla BI

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

List.Accumulate in Power Query (Explained with Examples)

4th July 2022 by Rick de Groot Categories Power Query

List.Accumulate is a one of the more complex Power Query functions that is not well understood. It allows you to perform an action repeatedly and …

Read more

Categories Power Query

Create Date Table with Dynamic Language in Power Query

28th June 2022 by Rick de Groot Categories Power Query

The Date table is an essential piece of every data model. And when you work with different users, some users look for one in English …

Read more

Categories Power Query

Creating Tables in Power Query M (40+ Examples)

28th June 2022 by Rick de Groot Categories Power Query

Tables have a fundamental place in Power Query. Most transformations you make are based on tables and mastering how they work helps you in your …

Read more

Categories Power Query
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

21st June 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
Extract Date From Text in Power Query

How to Extract Dates From Text String in Power Query

21st June 2022 by Rick de Groot Categories Power Query

This post shows how to transform a text string into a date in Power Query. You may work with integers or text values that represent …

Read more

Categories Power Query
Text Functions in Power Query

Text Functions in Power Query M (150+ Examples)

21st June 2022 by Rick de Groot Categories Power Query

Text functions are foundational in your Power Query journey. They allow you to analyze and manipulate text values. And once you master them you will …

Read more

Categories Power Query
List.Generate in Power Query

List.Generate in Power Query: Tutorial with Easy Examples

28th June 2022 by Rick de Groot Categories Power Query

List.Generate is powerful function that allows you to create lists of values based on logic. This can be a list with text or numbers, but …

Read more

Categories Power Query
API calls with List.Generate

How to use List.Generate to make API Calls in Power Query M

21st June 2022 by Rick de Groot Categories Power Query

The List.Generate function allows you to create a series of values based on logic. What makes List.Generate so powerful is that it can perform a …

Read more

Categories Power Query
List Functions in Power Query

Lists in Power Query M / List Functions (200+ Examples)

21st June 2022 by Rick de Groot Categories Power Query

Lists in Power Query are often used for data transformations. You commonly find lists of numbers, letters, times, dates etc. And these lists are useful …

Read more

Categories Power Query
Post navigation
Older posts
Page1 Page2 … Page5 Next →
+ More

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

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

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

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© 2022 Gorilla BI
Next Page »