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
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,1870
Antriksh Sharma
Feb 5, 20233 min read
Extract model.bim file from Power BI & SSAS Tabular with Python
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,...
2,7351
Antriksh Sharma
Mar 10, 20227 min read
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...
5960
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...
4790
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,...
6280
Antriksh Sharma
Sep 26, 20213 min read
How to extract measures from Power BI to Excel or Text file?
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...
5,0921
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,1720
Antriksh Sharma
Jul 23, 20212 min read
How to Load Data From Power BI into SQL Server?
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...
1,1530
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,5770
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...
6871
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,5720
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...
6240
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,...
8250
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,0440
Antriksh Sharma
Mar 1, 20211 min read
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...
2110
Antriksh Sharma
Feb 10, 20212 min read
DAX Studio: Building Queries Manually (Using UI)
Since June 2020 a new feature has been introduced in DAX Studio https://daxstudio.org/ that allows you to design queries using the UI,...
1320
bottom of page