Knowing how to use the CALCULATE function is like knowing a cool super power. We’re going to learn the basics of it today, but it’s extremely versatile.The CALCULATE function performs a calculation on data but then lets you specify what data you want that calculation done on. Let’s try it out. We’re…
This post is a little different. No video this week, because we’re talking about Power BI Licenses. Not the most exciting thing in the world but *immensely* important to understand when it comes to sharing Power BI reports in your organization. Let’s learn about how Power BI license levels affect…
The COUNT function in DAX is nice and easy. Let’s learn what it does (I think you can guess what it does) so we can all use it when we need it in our DAX measures. We’re using a very simple dataset to learn the COUNT function. If you’d like…
The SUMX function in DAX is very similar to the SUM function (makes sense, right?) but with 1 key difference We’re going to use a very simple dataset to demonstrate how the SUMX function works.If you’d like to use the same data that I do in the below video, here…
Oh, we’re getting a bit fancy with Power BI in this post! We’re going to learn how to change the data source of a report, and what you need when you do this so that everything doesn’t break. Not breaking things is a good goal, and not hard once you know what…
In this post we’ll explore how to write a simple SUM formula using DAX, and also show an example of how you may want to use it. We’re going to use a very simple dataset and report to demonstrate how the SUM function works.The written instructions as well the Power…
It’s always important to align visuals in Power BI. Alignment helps organize how your reports look and helps your reports look more professional.There are 4 main ways to align visuals and we’ll go over them all in this post. We’re going to use a Power BI report that already has…
It’s Hot Tip time here on How To Use Power BI, and for this tip, we’re going to learn about Display Folders, a little hidden feature in the Model View of Power BI Desktop. They are going to be your new best friend if you have to build reports with…
One of Power BI’s great strengths is that we can easily create visuals and entire dashboards using data from multiple data sources. As long as the data has something in common (ideally a unique identifier – we’ll talk about that in a minute), we can link data sources together and make…
In this post we’re going to learn how to format Pie Charts.I highly recommend that before learning from this post you watch/read the post about how to make a Pie Chart, which goes over how NOT to make them as well. Pie Charts are your best chart option in very…