• 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 BI

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
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
fuzzy matching in power query

Fuzzy Matching in Power Query

June 10, 2021 by Philip Treacy

Fuzzy matching is the ability to match non-identical text based on how similar one string is compared to the other. You may have text that has been entered as the answer to a survey question, in which case you can't control what the respondent types. This can result in misspelling of words, for example, take …

Read moreFuzzy Matching in Power Query
handling http errors in power query and power bi

Handling HTTP Errors in Power Query and Power BI

May 26, 2021 by Philip Treacy

If you are working with web servers, either because you are trying to scrape data or you are using a web based API, you will be sending and receiving data via HTTP. HTTP is the Hypertext Transport Protocol - it's just the name of the system used by web sites to transfer data. You use …

Read moreHandling HTTP Errors in Power Query and Power BI
extract characters from strings in power query using text select and text extract

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

May 13, 2021 by Philip Treacy

In this post I'm going to use the Text.Remove and Text.Select functions in PQ to extract characters from text strings. I'll show you how to extract letters, either uppercase or lowercase, and a mixture of both, and how to extract numbers, and I'll show you a really cool way to remove a wide range of …

Read moreExtract Letters, Numbers, Symbols from Strings in Power Query with Text.Select and Text.Remove
highlighting data in power bi visuals

Highlighting Data in Power BI Visuals

April 29, 2021 by Philip Treacy

In this post I'll be looking at ways to highlight or label values that may be of special interest in visuals. Perhaps you are interested in seeing the minimum and maximum values, or some data points of significance like when your business held a promotion. Or you might want to highlight points that fall within …

Read moreHighlighting Data in Power BI Visuals
shape maps in power bi

Shape Maps in Power BI

April 15, 2021 by Philip Treacy

In this post I'm going to show you how to use Shape Maps in Power BI, which are currently a preview feature. Typically, Shape Maps are used to illustrate the variation of a variable across a geographic area like a country or state. But you can also create custom shape maps for things like buildings, …

Read moreShape Maps in Power BI

Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI

March 11, 2021 by Philip Treacy

When you deal with elapsed time in Power Query you can make use of the Duration data type. Howevere when you load this into the Data model in either Power Pivot or Power BI, these durations are converted to decimal values. This post looks at how to use DAX to convert these decimals into human …

Read moreConverting Decimal Time to Days, Hours, Minutes, Seconds in Power BI
sort by column in power bi

Sort-By Columns in Power BI

February 18, 2021 by Philip Treacy

Normal sorting behaviour is to sort based on a numeric value, either higher to lower or lower to higher. But what if you want to have a custom sort order, or you are trying to sort categorical data in a specific way. How do you do that? Let's look at an example. The school our …

Read moreSort-By Columns in Power BI
custom formatting strings in power bi

Custom Formatting Strings in Power BI

January 28, 2021 by Philip Treacy

You may be familiar with Custom Format Strings in Excel, if you are not then check this Excel Custom Number Format Guide. What you might not know is that you can also use custom number formats in Power BI, and not only can you format columns of data, these custom formats can be applied to …

Read moreCustom Formatting Strings in Power BI
Power BI Dashboards

How to Build Power BI Dashboards

November 3, 2020 by Mynda Treacy

Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can make knowing which one to learn overwhelming. Global research and advisory firm, Gartner, has recognised Power BI as the Magic Quadrant Leader in analytics and business intelligence platforms for 13 consecutive years. This is just …

Read moreHow to Build Power BI Dashboards
using jitter to avoid over plotting

Using Jitter to Avoid Over Plotting in Power BI

January 11, 2020 by Philip Treacy

If you need to plot data that has one variable where values can be the same or very similar, for example the age of a group of people, you'll likely end up with data points that are plotted over the top of each other. To make this type of plot easier to read and allow …

Read moreUsing Jitter to Avoid Over Plotting in Power BI
real time data in power bi using pubnub

Real Time Data in Power BI Using PubNub

July 27, 2018 by Philip Treacy

In this post I'm going to look at getting real time data (RTD) into Power BI using a real time messaging service called PubNub. This is intended for use with the Power BI online service, not Power BI Desktop. Power BI provides a few different ways to get RTD : Push Data, Streaming Data and …

Read moreReal Time Data in Power BI Using PubNub

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.