Skillwave – Learn Power BI from Industry Experts
Seriously, I am so excited! And no, this is not an April fool’s joke! This is an actual picture of Ken, Miguel and me from a few hours ago. Introducing Skillwave Training Today I am …
New Instructor Led Online Power BI Training Classes
Well Covid-19 is a right royal pain in the backside for everyone. Am I right, or am I right? Everyone is effected to some extent, of course some more than others. One implication for me is …
New Instructor Led Online Power BI Training Classes Read More
Introduction to Tabular Editor for Business Users
Tabular Editor is a community Open Source software project written by Daniel Otykier. I have known about this product for several years but never really invested the time to understand what it does and how …
Adding Semesters to a Calendar in Power BI
I have delivered Power BI training at a number of universities over the last 6 months, and a few of the participants asked me the same question. “What is the best way to add semesters …
Scraping data from JavaScript web sites with Power Query
In a recent post, Matt discussed how to extract data from complex websites with Power BI using the New Web Table Inference capability of Power Query. This article is an extension of those ideas, revealing …
Scraping data from JavaScript web sites with Power Query Read More
From Marine Biologist to Power BI Pro
Matt here: If you are a regular reader of my blog, you may remember that late in 2019 I advertised for a full time trainer to join my company. I have been in business for …
Gartner Magic Quadrant for Business Intelligence – 2020 Update
Updated Feb 2020 Gartner released the 2020 magic quadrant for Business Intelligence early in Feb 2020. As expected (by me at least), Microsoft is continuing its trail blazing and has maintained a clear lead over …
Gartner Magic Quadrant for Business Intelligence – 2020 Update Read More
Joining Tables on 2 Columns in Power BI
I was delivering an advanced DAX class recently and was chatting with the bright students in the class about various topics. Through the discussions it occurred to me that it may be possible to create …
Remove Duplicates and Keep the Last Record with Power Query
Today I was helping a customer with a problem that seemed quite simple on the surface. She had a data table containing historical customer sales orders (each customer has many orders on different dates). The …
Remove Duplicates and Keep the Last Record with Power Query Read More
Dual Axis Line Chart in Power BI
As most readers of my website would surely know, Microsoft Excel has had a dual axis line chart as a standard charting visual for many many (many) years. A dual axis line chart is needed …
Extracting Data from Complex Web Pages with Power BI
Back in 2018 I wrote an article showing how to extract data from websites using Power Query in Excel. For simple websites this process is very straightforward. For more complex websites the process is not …
Extracting Data from Complex Web Pages with Power BI Read More
I’m Hiring A Power BI Trainer/Consultant
Edit: 27th Nov 2019. Note applications for this job are now closed. Meet Jason, my full time trainer. It is 5.5 years since I left my 25 year corporate role at Coca-Cola and started my …
Microsoft Renames Flow to Power Automate
Last week in Orlando Florida, Microsoft held its annual Ignite conference. I have never been to Ignite but it is on my list of things to do in the future. There are always lots of …
Show the Tickets Assigned to Me (or Others)
I stumbled across an interesting problem recently when helping someone on a forum. Here is the scenario. Assume there is a help desk that is logging tickets into a system. Each ticket is assigned to …
Combining Multiple Sheets from Multiple Workbooks
I have written a series of articles where I explained different methods of combining data from multiple files into a single workbook/table using Power Query. In the first article, I explained how to create a …
Matt’s Power BI World Tour
I have been planning for various speaking and training events over the last 6 months and these events are now rapidly approaching. As it turns out, it seems I have a bit of a world …
Power BI Webinar Overflow Q&A
Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register …
REMOVEFILTERS() in DAX
Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as …
Is my Power BI Report Filtered?
I was delivering Power BI training in Melbourne last week and one of my students asked if it was possible to show on a report if any filters have been applied. It is a very …
Free Webinar: Introduction to DAX for Power BI
On 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live …