top of page
Power BI | Excel | Python | SQL
Search

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...
Antriksh Sharma
Mar 10, 20227 min read
649
0

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,...
Antriksh Sharma
Nov 18, 20214 min read
641
0

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...
Antriksh Sharma
May 29, 20215 min read
2,727
0


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...
Antriksh Sharma
May 4, 20215 min read
3,751
0

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...
Antriksh Sharma
May 2, 20214 min read
657
0

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,...
Antriksh Sharma
May 1, 20213 min read
853
0
bottom of page