In this blog let's take a look at why your DAX calculations are returning 100% instead of a fraction of the grand total. In DAX you can...

I have been thinking about this for a while, a series of blogs where I try to explain how a particular piece of DAX code works. For this...

DAX doesn't have the concept of global variables so reusing a piece of code by referencing it somewhere else isn't possible, luckily the...

While working with DAX, a common mistake that anyone makes (that I also made) is to think that applying a filter on a column of a...

One thing that we are used to is ALL functions ignore filters and return either a unique value or complete table when used as a table...

One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...

In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...

In this blog I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...

In this blog let's see how to compute value of the measure for every other value of a column except for the one that is currently visible...

In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...

PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...

Creating running totals on a numeric or date field is pretty easy because you always have something that you can use to compare against...

One of a very common requirement that I have seen is to be able to filter out the selection made in the slicer from a visual such as a...

Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...

In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...

Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...

Creating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...