Intermediate - Excelerator BI

Intermediate

Large Customer Sales

The FILTER Function in DAX Part 2

Level: Intermediate In my last article, I introduced the basics of the DAX FILTER() function. Hopefully that introductory explanation to FILTER() helped you get your head around what FILTER() is doing under the hood. With …

The FILTER Function in DAX Part 2 Read More

072419 0359 Thefilterfu2.png

The FILTER Function in DAX

Level: Intermediate FILTER() is one of the most important functions in the DAX language. It is quite a simple function and yet many people are scared off when they see it. In this article I …

The FILTER Function in DAX Read More

Final Chart 2

Pareto Analysis in Power BI

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presumption that a relatively …

Pareto Analysis in Power BI Read More

Slicerwithhistogram

Slicer with Histogram in Power BI

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points.  I thought it was pretty cool, so decided to see if I …

Slicer with Histogram in Power BI Read More

Power BI APIs for Non-Programmers

Level: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar.  I don’t always read the more technical announcements because I don’t have a highly technical background.  …

Power BI APIs for Non-Programmers Read More

Solving a Complex Time Problem In Power BI

Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window.  Think …

Solving a Complex Time Problem In Power BI Read More

Six Sigma Control Charts in Power BI

Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart.  Now I am not professing to …

Six Sigma Control Charts in Power BI Read More

Expanding Rows Using Power Query

I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a …

Expanding Rows Using Power Query Read More

Simple Filters and Syntax Sugar in DAX

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use …

Simple Filters and Syntax Sugar in DAX Read More

calendar overrun in Power BI

Calendar Over Run While Comparing Last Year’s Data

Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share with others. …

Calendar Over Run While Comparing Last Year’s Data Read More

Copy measures between PBIX files

Copy Measures Between 2 Power BI Files

I have often been asked (and wondered myself) if it were possible to move all the measures from one Power BI PBIX file into another.  Imagine you have 2 PBIX files with similar data models …

Copy Measures Between 2 Power BI Files Read More

Import First Sheet with Power Query

Import the First Sheet in a Workbook with Power Query

My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in …

Import the First Sheet in a Workbook with Power Query Read More

Combine All Sheets in a Workbook with Power Query

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you …

Combine All Sheets in a Workbook with Power Query Read More

Load latest file in Power BI

Load the Latest Version of a File with Power Query

There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your …

Load the Latest Version of a File with Power Query Read More

Rename Blank in a Slicer in Power BI

A common problem I see some people struggle with in Power BI is when a slicer contains a (Blank) record for some reason.  The cause of the problem is not obvious and hence it is …

Rename Blank in a Slicer in Power BI Read More

When to Use SUM() vs SUMX()

Level: Beginners/Intermediate (Updated Oct 2018). This is a further (third) update/edit to an article I first wrote 3 years back and then updated a year back.  When I update my articles I simply change the …

When to Use SUM() vs SUMX() Read More

Create a Power BI Slicer Panel

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers.  When this happens, you only get half the page to visualise the actual data.  But …

Create a Power BI Slicer Panel Read More

My Presentations at the MS Summit and Portland UG

I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit (MBAS). I love attending conferences like this and it was a privilege to present on a few topics …

My Presentations at the MS Summit and Portland UG Read More

Extending Power BI With R Visuals

Level: Intermediate Matt: This is the second one in a series of articles from Parker Stevens. In this article he talks about using R with Power BI. If you missed his first article “Introduction to …

Extending Power BI With R Visuals Read More

Extracting Complex Data from Websites

One thing I did a long time ago was set up my own forum called PowerPivot Forum. This forum is open to anyone to join and to ask questions and/or help others. If I have any spare …

Extracting Complex Data from Websites Read More

Scroll to Top