Tag Archives: PercentileX.Inc

Calculating Quartiles with DAX and Power BI

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 to demonstrate how I accomplished this using DAX in Power BI. For this example, I’m going to be using the NFL dataset that I download as part of my NFL analysis dashboards I published last week.

image

Continue reading Calculating Quartiles with DAX and Power BI