Power BI | DAX | Excel | VBA | Python | SQL

  • All Posts
  • DAX
  • CALCULATE
  • Power BI
  • DAX Studio
  • Tabular Editor
  • Running Totals
  • Visualization
  • Power BI Service
  • DAX Optimizations
  • Power Query
  • M
  • Circular Dependency
  • SQL
  • About Me
  • DAX Functions
  • VBA
  • Excel
  • Tableau
Search
Dynamically Remove Null Columns in Power Query with M code
Antriksh Sharma
  • Jul 1, 2021
  • 2 min

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...
1,7881
Show measures in Power BI based on slicer selection
Antriksh Sharma
  • Jun 30, 2021
  • 1 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....
550
Create relationships in Power BI with Tabular Editor
Antriksh Sharma
  • Jun 24, 2021
  • 1 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...
5601
Dynamically change column names in Power Query using predefined values
Antriksh Sharma
  • Jun 17, 2021
  • 1 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...
970
Create Calculated Table in Power BI with Tabular Editor
Antriksh Sharma
  • Jun 8, 2021
  • 1 min

Create Calculated Table in Power BI with Tabular Editor

Out of the box TE doesn't allows you to create Calculated Table in Power BI, but if you want you can easily do that. To be able to create...
1610
Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.
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...
6570
Option Private Module in VBA - Prevent users from accessing sub-routine or functions.
Antriksh Sharma
  • May 26, 2021
  • 1 min

Option Private Module in VBA - Prevent users from accessing sub-routine or functions.

VBA allows you to create sub-routines or functions that can be hidden from the end user using only Excel interface, but sometimes that...
1402
Inverse SUM in DAX
Antriksh Sharma
  • May 24, 2021
  • 3 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...
3410
ADDCOLUMNS Function in DAX for Power BI, Power Pivot and SSAS
Antriksh Sharma
  • May 12, 2021
  • 4 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...
1,7170
Antriksh Sharma
  • May 9, 2021
  • 1 min

About me

Website: https://www.antmanbi.com/ YouTube: https://www.youtube.com/channel/UCDnIr1sOkcguc_h30XWCAaw/videos LinkedIn:...
1870
SQL to DAX: Select/Project Columns
Antriksh Sharma
  • May 7, 2021
  • 1 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...
620
Circular Dependency between Calculated Columns in a Table in DAX
Antriksh Sharma
  • May 4, 2021
  • 4 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...
1,5360
Clean a string using M in Power Query
Antriksh Sharma
  • May 3, 2021
  • 1 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...
910
Why you shouldn't add a 0 at the end of a DAX code
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...
910
Compute PARALLELPERIOD without using PARALLELPERIOD in DAX
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,...
3000
IF vs IF.EAGER - Optimizing DAX Calculations in Power BI
Antriksh Sharma
  • Apr 20, 2021
  • 0 min

IF vs IF.EAGER - Optimizing DAX Calculations in Power BI

140
Create static Row Level Security in Power BI
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...
670
Extract numbers from an alphanumeric string using DAX
Antriksh Sharma
  • Apr 16, 2021
  • 3 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...
2,5800
Create beautiful themes for Power BI
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...
2260
How to create Running Total on Non-Numeric Fields in Power BI using DAX
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...
5040
How To Exclude Slicer Selection from the result with DAX in Power BI
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...
3,0780
Sneak Peak of a code inside a DAX Measure
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...
400
DAX | CALCULATE | March’ 2021 Update
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...
730
Power BI: Visualizing Filter context
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...
530
1
2
3
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.