Welcome to our post all about how to know when you should make a new column OR a new measure using DAX in Power BI, because sometimes it can be confusing about what is better. The answer, like most things, is “it depends”. If you want to use the…
Welcome to our post all about the DISTINCTCOUNT function in DAX, because sometimes a COUNT isn’t good enough because it counts duplicates. If you want to use the same Power BI file I use in the below video and written notes to try out DISTINCTCOUNT, here’s the pbix file…
Welcome to the DAX:FORMAT post, where we’re going to learn the basics of the FORMAT function to format numbers for different circumstances. We’re going to use a simple Power BI file to get to know how to do this. If you’d like to use the same file, you can download…
Let’s learn how to use a fun little DAX function called SWITCH. The SWITCH function does just what it sounds like. It switches (see?) one value/thing for another value/thing. Or a list of values/things for a list of other values/things. We’re going to use a simple Power BI file to…
Hey everyone, This post is all about the MAX function in DAX, which does exactly what you think it does… it finds the maximum value in a column of values. We’re going to use a very simple Power BI report (in both the video and the written post below) to…
Did you ever have a large DAX calculation that had something (a column, another measure, etc) mentioned many times and when you had to change that item you had to select each one, one-at-a-time, and edit each one, one-at-a-time, and you thought “there’s gotta be a better way…?!” Good news!…
If you’ve already checked out the post about the IF function (I recommend it if you haven’t used IF functions in Power BI or in Excel before), this post is about how to use multiple IF statements nested within each other to check for different scenarios in your data.
The IF function in DAX is at once one of the simplest DAX functions and also one of the most powerful. If you’ve used the IF Excel formula in spreadsheets before, you’ll be happy to know that the IF DAX function behaves exactly the same. We’re going to use a…
The ALL function in DAX is a simple yet extremely versatile function that let’s us override any filters or slicers that may be affecting what data is coming into a calculation or visual. We’re going to learn how it works with a simple example using a CALCULATE function. (I…
We’re taking on the simple yet incredibly useful DIVIDE DAX function today. This function has a cool piece in it that accounts for when your denominator is a 0. When you divide numbers in Excel, you’ll get at #DIV/0! error when your denominator is a 0 (because nothing can be…