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
Previous Year calculation in case of missing years in DAX.
Antriksh Sharma
  • Aug 3, 2021
  • 2 min

Previous Year calculation in case of missing years in DAX.

One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...
2400
How to create Running Total in Power BI: The Basics
Antriksh Sharma
  • Jul 12, 2021
  • 4 min

How to create Running Total in Power BI: The Basics

In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...
1,4080
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...
5510
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...
3140
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,4530
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,...
2460
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...
4260
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...
2,3950
DAX | CALCULATE | March’ 2021 Update
Antriksh Sharma
  • Mar 22, 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...
700
Thinking Behind Use of KEEPFILTERS in DAX
Antriksh Sharma
  • Feb 24, 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...
1460
Power BI DAX: Context Transition - Behind the scenes
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...
1080
Running Totals exclude days from the calculation
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...
3080
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.