Skip to content

Gorilla BI

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

Power Query

Extract Date From Text in Power Query

How to Extract Dates From Text String in Power Query

25th May 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)

25th May 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

29th December 2021 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

8th March 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)

19th April 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
Date Table in Power Query

Create Date Table or Calendar in Power Query M | including Script

22nd December 2021 by Rick de Groot Categories Power Query

This post describes how to create a dynamic date table using Power Query. Virtually every Power BI solution benefits from a date table. The date …

Read more

Categories Power Query
Image showing previous row value

Get Value from Previous Row using Power Query

31st October 2021 by Rick de Groot Categories Power Query

In this post you learn how to get the previous row value using Power Query. This is a useful skill to compare previous row value …

Read more

Categories Power Query
Thumbnail leading zeros before numbers

3 Ways to Add Leading Zeros to Numbers in Power Query

30th November 2021 by Rick de Groot Categories Power Query

A leading zero is any 0 you add before the first nonzero digit of a string. By definition, these are invisible when a value has …

Read more

Categories Power Query

Pivot Text Values in Power Query – Explained

31st October 2021 by Rick de Groot Categories Power Query

The above video breaks down how you can pivot text values in Power Query. The regular pivoting of numbers is straight forward. But when text …

Read more

Categories Power Query
Featured Image - Conditionally Replace values in Power Query

Replace Values in Power Query M (Ultimate Guide)

12th December 2021 by Rick de Groot Categories Power Query

Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …

Read more

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

  • 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
Next Page »