Antriksh Sharma
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,...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Apr 16, 2021
- 1 min
Create static Row Level Security in Power BI
RLS or Row Level Security allows admins to restrict the data access for a particular user. You can define RLS only in Power BI Desktop...
1010
Antriksh Sharma
- Apr 16, 2021
- 5 min
Extract numbers from an alphanumeric string using DAX
Extracting numbers from an alphanumeric string like "b52h1l1h8gyv3kb7qi3" and then summing or just concatenating those values is really...
5,3910
Antriksh Sharma
- Apr 10, 2021
- 2 min
Create beautiful themes for Power BI
What's the best way to create color schemes/themes for your Next Power BI report? Let's see that today! Credits - I learned this trick...
3010
Antriksh Sharma
- Apr 9, 2021
- 3 min
How to create Running Total on Non-Numeric Fields in Power BI using DAX
Creating running totals on a numeric or date field is pretty easy because you always have something that you can use to compare against...
8990
Antriksh Sharma
- Apr 9, 2021
- 7 min
How To Exclude Slicer Selection from the result with DAX in Power BI
One of a very common requirement that I have seen is to be able to filter out the selection made in the slicer from a visual such as a...
7,9550
Antriksh Sharma
- Apr 7, 2021
- 1 min
Sneak Peak of a code inside a DAX Measure
Wouldn’t it be awesome if we could sneak peak the code of a measure A when we are writing a different measure B and calling measure A...
650
Antriksh Sharma
- Mar 21, 2021
- 1 min
DAX | CALCULATE | March’ 2021 Update
Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...
840
Antriksh Sharma
- Mar 1, 2021
- 1 min
Power BI: Visualizing Filter context
If there is one thing every DAX developer has ever dreamt about is to be able to view the filter context inside Power BI to debug DAX...
1030
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...
3430
Antriksh Sharma
- Feb 10, 2021
- 2 min
DAX Studio: Building Queries Manually (Using UI)
Since June 2020 a new feature has been introduced in DAX Studio https://daxstudio.org/ that allows you to design queries using the UI,...
660
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...
1970
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...
6290
bottom of page