Fixing Lineage issue when JOIN-ing tables in DAX
DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
Oct 193 min read
Why DAX is returning 100%
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...
2130
Antriksh Sharma
May 168 min read
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...
8781
Antriksh Sharma
Apr 134 min read
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,5891
Antriksh Sharma
May 10, 20234 min read
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...
3,2490
Antriksh Sharma
Apr 28, 20231 min read
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...
3790
Antriksh Sharma
Apr 29, 20223 min read
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...
6220
Antriksh Sharma
Mar 28, 20225 min read
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,4580
Antriksh Sharma
Dec 20, 20212 min read
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...
4820
Antriksh Sharma
Nov 18, 20214 min read
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,...
6290
Antriksh Sharma
Sep 1, 20214 min read
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,1830
Antriksh Sharma
Aug 3, 20212 min read
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...
1,0710
Antriksh Sharma
Jul 12, 20214 min read
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,6290
Antriksh Sharma
Jun 30, 20211 min read
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....
1980
Antriksh Sharma
Jun 8, 20211 min read
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...
1,1880
Antriksh Sharma
May 29, 20215 min read
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,6050
Antriksh Sharma
May 24, 20213 min read
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...
8560
Antriksh Sharma
May 12, 20214 min read
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,6920
Antriksh Sharma
May 7, 20211 min read
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...
6941
Antriksh Sharma
May 4, 20215 min read
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,6060
Antriksh Sharma
May 2, 20214 min read
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...
6290
Antriksh Sharma
May 1, 20213 min read
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,...
8280
Antriksh Sharma
Apr 9, 20213 min read
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,0740
Antriksh Sharma
Apr 9, 20217 min read
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...
17,1400
bottom of page