• 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
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • 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 Custom Functions

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
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
grouped running totals in power query

Grouped Running Totals in Power Query

October 7, 2020 by Philip Treacy

In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals. I'll start with a table of data showing values for cities within different countries. Download the Workbook With Sample Query The queries in this Excel file can be copied/pasted into the Power BI Desktop Advanced …

Read moreGrouped Running Totals in Power Query
quickly create running totals in power query

Quickly Create Running Totals in Power Query

September 24, 2020 by Philip Treacy

A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values every step of the way. Creating a running total in Excel is easy. Mynda has written about a couple of ways you can do it Running Totals in Excel Running Totals in Excel Tables But …

Read moreQuickly Create Running Totals in Power Query
power query custom functions

Power Query Custom Functions

September 3, 2020 by Philip Treacy

If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically takes some input and gives you an output. The input, for example, could be a range, a number or a piece of text. The output type will vary, the SUM function will output a number, …

Read morePower Query Custom Functions

Blog Categories

  • 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
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

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.