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 SharmaFeb 23, 20212 min readThinking Behind Use of KEEPFILTERS in DAXIn this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...
Antriksh SharmaJan 20, 20215 min readPower BI DAX: Context Transition - Behind the scenesContext transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...
Antriksh SharmaNov 22, 20208 min readRunning Totals exclude days from the calculationCreating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...