FILTER - Excelerator BI

FILTER

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

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

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

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

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

Scroll to Top