CALCULATE when possible

calculate

As you start getting more comfortable with DAX, you’ll quickly discover that there are multiple ways to skin a cat. In this quick tip, I’m going to try and explain how calculate with filtering works, and more generally, how to use calculate when possible. Let’s jump straight in with an example. What if you wanted to, for example, sum the amount of sales where the amount was greater than one? We could do something like this: Measure = SUMX (

Continue Reading

The DateTime Data Type – Power BI Quick Tips

datetime data type

I thought I’d put together a short series of posts with some quick and simple tips that we can all adhere to. The aim is to help us improve our DAX queries and the general speed of our Power BI and/or SSAS tabular models. In this first tip, I’d like to talk about the use of the datetime data type in your tabular and Power BI models. Before we get to the tip itself, I’d like to talk about how

Continue Reading

Reverse engineering summarised data using DAX

Those who use Power BI, Analysis Services, or any other data modelling tool that uses DAX, will know that most of the time you will be taking very detailed data and in one way or another turning it into useful summarised data, as such is why we use reporting or dashboarding tools. The problem In most cases the source data you will have is relatively detailed, making it easy to create a data set that can be sliced by a particular data

Continue Reading

Site Footer