Antriksh Sharma
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...
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Mar 28
- 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...
7600
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...
2250
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,...
4150
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...
7240
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...
3420
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...
2,2540
Antriksh Sharma
- Jun 30, 2021
- 1 min
Show measures in Power BI based on slicer selection
One of the very common requirement of Power BI users is that of showing only those measures in a visual which are selected in a slicer....
730
Antriksh Sharma
- Jun 8, 2021
- 1 min
Create Calculated Table in Power BI with Tabular Editor
Out of the box TE doesn't allows you to create Calculated Table in Power BI, but if you want you can easily do that. To be able to create...
2880
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...
9290
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...
4160
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...
2,2910
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...
840
Antriksh Sharma
- May 4, 2021
- 4 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...
1,7470
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...
1320
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,...
3860
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...
6880
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...
4,9040
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...
780
Antriksh Sharma
- Mar 1, 2021
- 1 min
Power BI: Visualizing Filter context
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...
730
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...
2800
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...
1590
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...
4640