Antriksh SharmaMar 10, 20227 min readGetting started with Aggregations in Power BI - Part 1In 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 SharmaNov 18, 20214 min readDependency of a function on Row Context in DAXHave 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 SharmaMay 29, 20215 min readOptimizing 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 SharmaMay 4, 20215 min readCircular Dependency between Calculated Columns in a Table in DAXIn this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...
Antriksh SharmaMay 2, 20214 min readWhy you shouldn't add a 0 at the end of a DAX codePower BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...
Antriksh SharmaMay 1, 20213 min readCompute PARALLELPERIOD without using PARALLELPERIOD in DAXPARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...