Understanding how Time Intelligence functions are evaluated in Row Context
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...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Apr 13
- 4 min
Using DETAILROWS with WINDOW functions in DAX
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...
1,3781
Antriksh Sharma
- May 10, 2023
- 4 min
Applying a Filter on Dimension vs Fact in DAX
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...
2,9970
Antriksh Sharma
- Apr 28, 2023
- 1 min
ALL Functions vs Security in DAX
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...
3620
Antriksh Sharma
- Apr 29, 2022
- 3 min
Complex behaviour of slicers in Power BI
Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...
6110
Antriksh Sharma
- Mar 28, 2022
- 5 min
Full Outer Join in DAX in Power BI and SSAS Tabular
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...
3,2560
Antriksh Sharma
- Mar 10, 2022
- 7 min
Getting started with Aggregations in Power BI - Part 1
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...
5730
Antriksh Sharma
- Dec 20, 2021
- 2 min
Storing a column as String or Integer in Analysis Services
Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...
4710
Antriksh Sharma
- Nov 18, 2021
- 4 min
Dependency of a function on Row Context in DAX
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,...
6230
Antriksh Sharma
- Sep 16, 2021
- 1 min
Tabular Editor 3 Course
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...
1170
Antriksh Sharma
- Sep 1, 2021
- 4 min
SUM vs SUMX in DAX
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...
2,1340
Antriksh Sharma
- Aug 3, 2021
- 2 min
Previous Year calculation in case of missing years in DAX.
One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...
9950
Antriksh Sharma
- Jul 12, 2021
- 4 min
How to create Running Total in Power BI: The Basics
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...
7,1680
Antriksh Sharma
- May 29, 2021
- 5 min
Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.
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...
2,5070
Antriksh Sharma
- May 24, 2021
- 3 min
Inverse SUM in DAX
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...
8110
Antriksh Sharma
- May 12, 2021
- 4 min
ADDCOLUMNS Function in DAX for Power BI, Power Pivot and SSAS
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...
5,5230
Antriksh Sharma
- May 7, 2021
- 1 min
SQL to DAX: Select/Project Columns
In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...
6671
Antriksh Sharma
- May 4, 2021
- 5 min
Circular Dependency between Calculated Columns in a Table in DAX
In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...
3,5200
Antriksh Sharma
- May 2, 2021
- 4 min
Why you shouldn't add a 0 at the end of a DAX code
Power BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...
5990
Antriksh Sharma
- May 1, 2021
- 3 min
Compute PARALLELPERIOD without using PARALLELPERIOD in DAX
PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...
8170
Antriksh Sharma
- Apr 16, 2021
- 5 min
Extract numbers from an alphanumeric string using DAX
Extracting numbers from an alphanumeric string like "b52h1l1h8gyv3kb7qi3" and then summing or just concatenating those values is really...
11,0490
Antriksh Sharma
- Apr 9, 2021
- 3 min
How to create Running Total on Non-Numeric Fields in Power BI using DAX
Creating running totals on a numeric or date field is pretty easy because you always have something that you can use to compare against...
2,0070
Antriksh Sharma
- Apr 9, 2021
- 7 min
How To Exclude Slicer Selection from the result with DAX in Power BI
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...
16,7390
Antriksh Sharma
- Mar 21, 2021
- 1 min
DAX | CALCULATE | March’ 2021 Update
Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...
1010
bottom of page