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
July 22, 2021
Auto Refresh PivotTables
In this tutorial we’re going to look at the options we have available to auto refresh PivotTables in Excel without
Read More
July 15, 2021
Power Pivot Running Total
In this tutorial we’ll look at how to create a Power Pivot running total that allows you to see the
Read More
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
Read More
June 16, 2021
Show Items with no Data in PivotTables
Show Items with no Data in PivotTables is a handy setting that allows you to show items in the PivotTable
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 20, 2021
Non-financial Excel Dashboards
Dashboards give a visual snapshot of your business performance. They typically show data spread over time and grouped by category.
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
May 5, 2021
Share and Collaborate in Excel
We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently
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 27, 2021
Secrets to Building Excel Dashboards in Under 15 Minutes
Building Excel Dashboards doesn't need to be a slow process. When your data is structured correctly you can use the
Read More
April 21, 2021
Power BI Organizational Data Types in Excel
Power BI Organizational Data Types in Excel allow you to store attributes about your data in a single cell. This
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
April 7, 2021
Excel Workbook Protection
When you spend days crafting your latest report, the last thing you need are well meaning users messing with your
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 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
Read More
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
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
March 4, 2021
Recursive LAMBDA Functions
The new Excel LAMBDA function that we looked at last week also enables us to write custom recursive LAMBDA functions.
Read More
February 25, 2021
Excel LAMBDA Function
The new Excel LAMBDA function allows you to define your own custom functions using Excel’s familiar formula language. That means
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
February 11, 2021
Excel Pyramid Charts
Excel pyramid charts are easy to build using bar charts or Conditional Formatting, but there are a few rules you
Read More
February 4, 2021
Personal Stock Portfolio Dashboard
Keeping track of your share trading is easy with this personal stock portfolio dashboard. It uses the latest Excel tools*
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 21, 2021
Highlighting Periods in Excel Charts
Shading or highlighting periods in Excel charts can help users more quickly interpret them and identify patterns. In the chart
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