Power Query Archives • My Online Training Hub

July 23, 2024

Excel Data Cleaning Shortcuts

Handling messy data is a common challenge for anyone working with Excel. Tasks such as splitting columns, merging tables with

November 28, 2023

Import Data From Web to Excel

We now have a new, improved way to import data from the web to Excel. Just like in Power BI,

July 18, 2023

Get Started with Power Query

Efficiencies gained from Power Query can be life changing. I’m not exaggerating. Power Query can reduce time spent gathering and

March 23, 2023

Power Query if Statements incl. Nested ifs, if or, if and

Power Query if statements, nested if, 'if or' and 'if and' statements are a bit different to writing IF formulas

August 4, 2022

Power Query Variables 3 Ways

Power Query variables are a great way to store data that can be used multiple times and can be easily

delete empty rows and columns using power query

April 21, 2022

Remove Blank Rows and Columns from Tables in Power Query

When you import data to Power Query, it's not unusual to end up with a table containing blank rows and

extracting data from lists and records in power query

April 7, 2022

Extracting Data from Nested Lists and Records in Power Query

You may have data that is contained in lists or records, or even lists inside records, or records inside lists.

March 3, 2022

Combine Files With Different Column Names in Power Query

I'm going to look at situations that appear to be fairly common: loading data into Power Query where the source

December 2, 2021

Power Query Keyboard Shortcuts to Save Time

Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and

November 11, 2021

Remove Text Between Delimiters – Power Query

This is my source data and I want to remove the percentages Specifically I want to remove all occurrences of

October 28, 2021

Tips for Using The Power Query Advanced Editor

If you've only ever used the user interface (Ribbon and menus) to create your transformations then you're missing out on

pivot unknown variable number of rows to columns

October 7, 2021

Pivot an Unknown Number of Rows into Columns

Sometimes you have a table of data that describes a 1 to many relationship. The number of values on the

August 19, 2021

IFERROR in Power Query Using TRY OTHERWISE

In Excel we can use IFERROR to if our calculation results in an error, and we can then tell Excel

August 5, 2021

Easily Compare Multiple Tables in Power Query

Comparing table columns in Excel is a common task. You may need to identify items that are the same, different,

July 29, 2021

VLOOKUP in Power Query Using List Functions

If you've done lookups in Power Query to pull values from one table into another, you may have used a

July 8, 2021

Secret Power Query Function List

Hidden inside both Excel and Power BI is a secret Power Query function list that you can bring up while

June 10, 2021

Fuzzy Matching in Power Query

Fuzzy matching is the ability to match non-identical text based on how similar one string is compared to the other.

May 26, 2021

Handling HTTP Errors in Power Query and Power BI

If you are working with web servers, either because you are trying to scrape data or you are using a

extract characters from strings in power query using text select and text extract

May 13, 2021

Extract Letters, Numbers, Symbols from Strings in Power Query with Text.Select and Text.Remove

In this post I'm going to use the Text.Remove and Text.Select functions in PQ to extract characters from text strings.

March 31, 2021

Static Tables in Power Query, Power Pivot and Power BI

Ordinarily when you want to create a table in Power Query, Power Pivot or PBI, you'd write a query to

March 25, 2021

Change Type Using Locale with Power Query

One of the most common issues I help people fix is data imported to Excel or Power BI using Power

March 18, 2021

Get Data from OneDrive or SharePoint with Power Query

Nowadays many of us are saving our files to the cloud using OneDrive for Business or SharePoint Online. Unfortunately, it’s

February 18, 2021

Sort-By Columns in Power BI

Normal sorting behaviour is to sort based on a numeric value, either higher to lower or lower to higher. But

January 14, 2021

Table Statistics from Table.Profile in Power Query

It's often useful to know some quick statistics about our data. Things like the minimum or maximum values, or the

changing power query data source settings

December 16, 2020

Changing Data Source Location in Power Query

Here's the scenario - you've created a query in Power Query that loads data from a source, either a file

November 24, 2020

Dense Ranking in Power Query

There are several ways to rank things, dense ranking is when items that compare equally receive the same ranking number,

October 29, 2020

Create a List of Matching Words When Searching Text in Power Query

My previous post searched for text in columns and returned a true/false result if a match was found. This post

October 22, 2020

Searching for Text Strings in Power Query

Let's say we have a column of text and we want to search it to see if each row contains

October 15, 2020

Introduction to Power Query

What’s the big deal about Power Query? Talk to those who have used it and they’ll tell you how amazing

October 7, 2020

Grouped Running Totals in Power Query

In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals.