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...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
Feb 23, 20212 min read
Thinking Behind Use of KEEPFILTERS in DAX
In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...
6300
Antriksh Sharma
Jan 20, 20215 min read
Power BI DAX: Context Transition - Behind the scenes
Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...
4690
Antriksh Sharma
Nov 22, 20208 min read
Running Totals exclude days from the calculation
Creating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...
1,1200
bottom of page