CALCULATE - Excelerator BI

CALCULATE

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

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

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

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

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

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

Scroll to Top