Dynamically Remove Null Columns in Power Query with M code
I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
Jun 30, 20211 min
Show measures in Power BI based on slicer selection
One of the very common requirement of Power BI users is that of showing only those measures in a visual which are selected in a slicer....
1960
Antriksh Sharma
Jun 24, 20211 min
Create relationships in Power BI with Tabular Editor
Creating relationships in Power BI is as simple as it can get but to be able to edit/create relationships in Power BI with TE is...
1,9381
Antriksh Sharma
Jun 17, 20211 min
Dynamically change column names in Power Query using predefined values
In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...
7970
Antriksh Sharma
May 29, 20215 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...
2,5460
Antriksh Sharma
May 24, 20213 min
Inverse SUM in DAX
In this blog let's see how to compute value of the measure for every other value of a column except for the one that is currently visible...
8260
Antriksh Sharma
May 12, 20214 min
ADDCOLUMNS Function in DAX for Power BI, Power Pivot and SSAS
ADDCOLUMNS is a DAX table function that allows user to add new columns to the existing data. It has 3 main Arguments Table - The table on...
5,5850
Antriksh Sharma
May 7, 20211 min
SQL to DAX: Select/Project Columns
In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...
6751
Antriksh Sharma
May 4, 20215 min
Circular Dependency between Calculated Columns in a Table in DAX
In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...
3,5470
Antriksh Sharma
May 3, 20211 min
Clean a string using M in Power Query
In this blog I am going to show you how you can remove unwanted characters all at once from an improper text string like the following...
2460
Antriksh Sharma
May 2, 20214 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...
6060
Antriksh Sharma
May 1, 20213 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,...
8230
Antriksh Sharma
Apr 16, 20211 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...
1750
Antriksh Sharma
Apr 10, 20212 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...
3780
Antriksh Sharma
Apr 9, 20213 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...
2,0290
Antriksh Sharma
Apr 9, 20217 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...
16,9020
Antriksh Sharma
Apr 7, 20211 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...
840
Antriksh Sharma
Mar 21, 20211 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...
1010
Antriksh Sharma
Mar 1, 20211 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...
2070
Antriksh Sharma
Feb 23, 20212 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...
6130
Antriksh Sharma
Feb 10, 20212 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,...
1280
Antriksh Sharma
Jan 20, 20215 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...
4470
Antriksh Sharma
Nov 22, 20208 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...
1,1110
bottom of page