DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...

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...

Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...

DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...

In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...

Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...

Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...

TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for...

SUM and SUMX are both aggregation functions in DAX. While SUM allows you to aggregate only one Physical column of a table, SUMX is more...

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...

ADDCOLUMNS is a DAX table function that allows user to add new columns to the existing data. It has 3 main Arguments Table - The table on...

In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...

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

Power BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...

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

Extracting numbers from an alphanumeric string like "b52h1l1h8gyv3kb7qi3" and then summing or just concatenating those values is really...

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