• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Power Query

power query variables

Power Query Variables 3 Ways

August 4, 2022 by Mynda Treacy

Power Query variables are a great way to store data that can be used multiple times and can be easily updated in one place. There are a few ways you can create variables. 1. From the worksheet, which means you don’t even need to open the query editor to update the variable. This is great …

Read morePower Query Variables 3 Ways
delete empty rows and columns using power query

Remove Blank Rows and Columns from Tables in Power Query

April 21, 2022 by Philip Treacy

When you import data to Power Query, it's not unusual to end up with a table containing blank rows and columns, like this There are a few ways to get rid of these 'blank' rows and columns, some better than others. Watch the Video Download Example Excel Workbook Enter your email address below to download …

Read moreRemove Blank Rows and Columns from Tables in Power Query
extracting data from lists and records in power query

Extracting Data from Nested Lists and Records in Power Query

April 7, 2022 by Philip Treacy

You may have data that is contained in lists or records, or even lists inside records, or records inside lists. I've seen nested data like this come from API's or Sharepoint amongst other sources. In such cases you may want to extract only certain bits of data from the list(s) or record(s) and this blog …

Read moreExtracting Data from Nested Lists and Records in Power Query
combine files with different column names in power query

Combine Files With Different Column Names in Power Query

March 3, 2022 by Philip Treacy

I'm going to look at situations that appear to be fairly common: loading data into Power Query where the source data has columns with different names. For example, in the following file received in August 2021, I have data that relates to various items over a 12 month period. What the data is showing is …

Read moreCombine Files With Different Column Names in Power Query
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

December 2, 2021 by Philip Treacy

Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and Power BI. Watch the video to see me demonstrate how to use them, and download a PDF containing all shortcuts. Watch the Video Download Power Query Shortcuts PDF Enter your email address below to download …

Read morePower Query Keyboard Shortcuts to Save Time
remove text between delimiters power query

Remove Text Between Delimiters – Power Query

November 11, 2021 by Philip Treacy

This is my source data and I want to remove the percentages Specifically I want to remove all occurrences of (00%) so my data ends up like this There's no native function in Power Query to do this so I'll have to write my own code. Watch the Video   Download Sample Excel Workbook Enter …

Read moreRemove Text Between Delimiters – Power Query
power query advanced editor tips

Tips for Using The Power Query Advanced Editor

October 28, 2021 by Philip Treacy

If you've only ever used the user interface (Ribbon and menus) to create your transformations then you're missing out on some neat things you can do by using the Power Query Advanced Editor. In this post I'd like to show you what's in the Advanced Editor, how you can write code in it and hopefully …

Read moreTips for Using The Power Query Advanced Editor
pivot unknown variable number of rows to columns

Pivot an Unknown Number of Rows into Columns

October 7, 2021 by Philip Treacy

Sometimes you have a table of data that describes a 1 to many relationship. The number of values on the Many side is unknown and can vary. So writing Power Query code to pivot this can be tricky. Let's look at an example. The first column is a list of the office locations of my …

Read morePivot an Unknown Number of Rows into Columns
try otherwise power query iferror

IFERROR in Power Query Using TRY OTHERWISE

August 19, 2021 by Philip Treacy

In Excel we can use IFERROR to if our calculation results in an error, and we can then tell Excel to produce a different result, instead of the error. Power Query doesn't have IFERROR but it does have a way of checking for errors and replacing that error with a default answer, it's called try …

Read moreIFERROR in Power Query Using TRY OTHERWISE
easily compare multiple tables in power query using list functions

Easily Compare Multiple Tables in Power Query

August 5, 2021 by Philip Treacy

Comparing table columns in Excel is a common task. You may need to identify items that are the same, different, or missing from these columns. In Power Query, table columns are lists and you can compare these lists using table merges. But merging can only be done on two tables at a time. If you …

Read moreEasily Compare Multiple Tables in Power Query
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 6
  • Next
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.