DAX

How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right? Why Test? Quality testing is one of those things that …

Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating differen

This week I’m doing something a little bit different. I wanted to post a challenge that I think could apply to many business scenarios, and see the different approaches that people might take…

In this tip, we will define some essential statistics terms about Lowess and demonstrate how to use this in Power BI.

Power BI Measures are a great way to calculate aggregations and summaries of your data. This article explains how you can use Boolean columns to add simple filters to your DAX Measures, and so make it…

“Play Write the greatest song formula in the world, or I’ll eat your souls.”-From “Tribute,” by Tenacious DAX A Do-It-Yourself Time Machine You remember the Great Precedence Project? Well, I have shelved it for now, for two reasons: Creating an exhaustive list of all the precedence rules in PowerPivot

Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When I got to this slightly more advanced understanding of FP&A, I started to see

Like many of my blog posts, this post is inspired by some work I was doing with a customer who had a requirement to calculate quartiles of a ranked set of data. So I thought I’d take a few minutes …

There have been a lot of posts over the years about how to use RANKX to create a measure, but not so many about how to use RANKX to create a measure that ranks a measure. In addition, nothing really definitive on how to aggregate measures. This post is intended to fix that. Essentially, a measure ...

Got a question today on how we can do KPI’s in the matrix or table with Power BI, just like we can with PowerPivot through the KPI functionality there. This is where the great SVG trick from…

Today I was challenged with a problem and did not find an easy solution to it online, so I decided to write this quick post on it. The challenge was to create a measure in Table1 that would sum on Tab…

Thanks to two recent Power BI features it now possible to generate a link on the fly using DAX to go to a new report and pass in any filters. (Alsop imagine linking to your favorite SSRS report !) …

This article describes possible optimization approaches to improve the performance of nested iterators in DAX. One of the possible reasons the execution of

Figure 1 View outside of my home office window May 2nd, 2018 Fairbanks, Alaska. Intro Hello, my name is Matthew Brice and I am guest broadcasting from my home office (via tape delay) in Fairbanks, Ala…

The August 2018 release of the Power BI Desktop adds expression-based conditional formatting rules to the conditional formatting options available for table and matrix visuals. As this is a general…

DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates like Excel, which is the reason why these limitations exi

I read this blog (and Matt Allington, and Ken Puls) pretty religiously. But PowerPivotPro is probably my favorite because it deals with a lot of real-world situations, not just technical solutions. So, I’m going to continue that theme and talk about a different kind of problem-solving. How many of you build

Many of us who have used this function have rarely if ever seen the VALUE argument of RANKX function in use. This post explores a very interesting use of this “VALUE” parameter BUT FIRST …LETS RECALL THE BASICS Here is the link to official Microsoft documentation RANKX takes the followin...

The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. This article explains these side effects a

DAX has many time intelligence functions that are often redundant, offering different shorter syntaxes for longer more generic functions. However, sometimes

When I read about the new conditional formatting by values feature in the August 2018 release of Power BI Desktop, my first thought was to write a blog post on how DAX can be used to generate the hex …

Hi, based on the last update Power BI video of SVG visualisation here is a measure, that creates simple KPI. User has to add reference for 3 values: Main Value, Goal and Max Value. Based on values KPI color is changing to green or red. User can also change colors or edit if function for color cha...

In August 2018, the Power BI team has released a new feature: conditional formatting by field value. This feature works for both background colors and font colors. Because different background colors …

In this Power BI Tutorial, Patrick looks at how to dynamically filter by today’s date. Using a date table, you can create a DAX measure that can then be used as a Power BI report-level filter to dynamically filter by today’s date within Power BI Desktop.

If you are an advanced Excel user already familiar with PivotTables, eventually you will surpass regular features Excel has to offer, and you will start using PowerPivot. Why? Because in today’s world it is all about Big data. There are so many sources available for analysis,the amount of data is bigger than ever and increasing each day with astonishing speeds....