June 2, 2022
Custom Tooltips in Power BI
When you hover your mouse over an element in a visual, like a column in a clustered column chart, a
Read More
May 19, 2022
Conditional Formatting in Power BI Tables and Matrices
Conditional formatting in Power BI visuals allows you to draw attention to, or highlight, data in text or numeric fields
Read More
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
Read More
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.
Read More
March 17, 2022
DAX Editor Keyboard Shortcuts
Writing DAX is hard enough. If there were some way to make the experience a little easier wouldn't that be
Read More
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
Read More
January 20, 2022
Fixing Incorrect Totals in DAX
Typically in Power BI visuals like a matrix or a table, and in pivot tables in Excel, we expect the
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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,
Read More
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
Read More
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.
Read More
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
Read More
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.
Read More
April 29, 2021
Highlighting Data in Power BI Visuals
In this post I'll be looking at ways to highlight or label values that may be of special interest in
Read More
April 15, 2021
Shape Maps in Power BI
In this post I'm going to show you how to use Shape Maps in Power BI, which are currently a
Read More
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
Read More
March 11, 2021
Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI
When you deal with elapsed time in Power Query you can make use of the Duration data type. Howevere when
Read More
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
Read More
January 28, 2021
Custom Formatting Strings in Power BI
You may be familiar with Custom Format Strings in Excel, if you are not then check this Excel Custom Number
Read More
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
Read More
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
Read More
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,
Read More
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
Read More
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
Read More
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.
Read More
September 24, 2020
Quickly Create Running Totals in Power Query
A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values
Read More