top of page
Power BI | Excel | Python | SQL
Search
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...
6220
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,...
6340
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,6660
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,6580
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...
6470
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,...
8300
bottom of page