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
663
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
646
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, 20216 min read
2,853
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,814
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
678
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
857
0
bottom of page