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…
Today we’re going to start learning all about Bookmarks in Power BI. Bookmarks can be used to do a lot of different things, but today we’re just going to learn the basics and future posts will explore different features and uses of them. A Power BI Bookmark can be…
Welcome everyone! This post is about how to fix one of the annoying things in Power BI that makes you say “What The…?” (or worse language) when it happens. Sometimes, when you get Power BI to do a calculation (a sum, a count, a division… lots of things) and it…
Everything you need to know about Bar Charts! Once you’ve connected to some data, you may want to build a Bar Chart. Bar Charts are easy to build, and more importantly, they are easy for people to understand.Bar charts compare categories of things by their value, using length. The following…
We’re here for more data documentation fun in this post. While we have a post about documenting our data tables and columns in Power BI Desktop proper, there’s also some unsung (but awesome) data *transformation* documenting options in Power Query Editor. Just like documenting where your data is…
This post is all about documenting what your columns and DAX measures are all about (and maybe why they exist) in Power BI. Your datasets (whether you use them with Power BI or not) should be documented regardless, but that’s a data governance topic for another place, but documenting your…
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…
This post is about the concept of Row Context in Power BI. This is SUPER important when it comes to writing DAX measures, but applies to visuals not using DAX as well. To explore more DAX posts, check the DAX tag. This post was made with…