Antriksh Sharma
Performance penalty of Measures in Filters Pane in Power BI
In this blog let's take a look at the performance of a report when you use a Measure in the Filter Pane. Let's say you have a data model...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Mar 10, 2022
- 7 min
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...
3230
Antriksh Sharma
- May 29, 2021
- 5 min
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...
1,4430
Antriksh Sharma
- May 2, 2021
- 4 min
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...
2640
Antriksh Sharma
- May 1, 2021
- 3 min
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,...
5320
Antriksh Sharma
- Feb 23, 2021
- 2 min
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...
4110
Antriksh Sharma
- Jan 20, 2021
- 5 min
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...
2240
Antriksh Sharma
- Nov 22, 2020
- 8 min
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...
7510
bottom of page