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


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,776
0


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...

Antriksh Sharma
Feb 23, 20212 min read
665
0


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...

Antriksh Sharma
Jan 20, 20215 min read
491
0


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...

Antriksh Sharma
Nov 22, 20208 min read
1,161
0
bottom of page