DAX - Excelerator BI

DAX

081019 0301 Dynamically1.png

Dynamically Show Completed Months in Power BI

One common requirement I have come across a few times is to limit a Power BI visual to only show completed months and exclude the current active month. This is common if you load data …

Dynamically Show Completed Months in Power BI Read More

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

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

Column Sub Folders are Better than Measure Sub Folders

I blogged about the various ways to use Measure tables and Measure Sub Folders in Power BI a few weeks back.  I discussed why measure tables may be required, and also a few reasons why you …

Column Sub Folders are Better than Measure Sub Folders 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

Conditional Formatting with a Text Field in Power BI

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI.  Last week, John asked me …

Conditional Formatting with a Text Field in Power BI Read More

Calculation Groups are Coming to DAX

I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits.  Microsoft is adding “Calculation Groups” to the DAX language. There are a number …

Calculation Groups are Coming to 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

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

Using Variables to Write Measures

It’s pretty early in the morning here in Sydney Australia (just after 6 am actually).  I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX …

Using Variables to Write Measures 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

User Specified Growth on an Investment using Power BI

Level: Intermediate I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment …

User Specified Growth on an Investment using Power BI Read More

Number of Days between 2 Transactions Using DAX

Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself).  While I was chatting I asked my hair dresser “on average, how often should I get my …

Number of Days between 2 Transactions Using DAX Read More

My Supercharge Excel and Supercharge Power BI Books Available on Amazon

After what seems like a lifetime of waiting for the paperback book economy to tick its required boxes, both of my new books Supercharge Excel and Supercharge Power BI are now available to ship to …

My Supercharge Excel and Supercharge Power BI Books Available on Amazon Read More

Time Intelligence Using DAX

Level: Intermediate Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence.  This was a YouTube broadcast event that anyone could join live, however it has also been …

Time Intelligence Using DAX Read More

Introduction to DirectQuery

Level: Intermediate to Advanced Matt here.  I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me.  Parker has shared a few techniques with me that I …

Introduction to DirectQuery Read More

Filtering a Column via a Visual AND CALCULATE

Level: Intermediate. Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you.  Such events can cause you to doubt your own learning and progress. But …

Filtering a Column via a Visual AND CALCULATE Read More

Show Me All Invoices Containing this Product

Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here.  I have modified the …

Show Me All Invoices Containing this Product Read More

Scroll to Top