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

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

Model.bim is a JSON file which is the skeleton of your Power BI or SSAS Model, using this file you can create a database from scratch,...

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

A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...

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

Whenever I work with LinkedIn data challenges a very common task for me is to load data into SQL Server as modifying the data in SQL is...

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

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

If there is one thing every DAX developer has ever dreamt about is to be able to view the filter context inside Power BI to debug DAX...

Since June 2020 a new feature has been introduced in DAX Studio https://daxstudio.org/ that allows you to design queries using the UI,...