Antriksh Sharma
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...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Apr 19
- 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...
7650
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...
5240
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...
3,5470
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...
1,4430
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...
5320
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...
2,1190
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,...
5320
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...
1,1480
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...
10,3170
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...
880
Antriksh Sharma
- Feb 23, 2021
- 2 min
Thinking Behind Use of KEEPFILTERS in DAX
In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...
4110
Antriksh Sharma
- Jan 20, 2021
- 5 min
Power BI DAX: Context Transition - Behind the scenes
Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...
2240
Antriksh Sharma
- Nov 22, 2020
- 8 min
Running Totals exclude days from the calculation
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...
7510
bottom of page