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
Getting started with Aggregations in Power BI - Part 1
Antriksh Sharma
  • Mar 10
  • 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...
920
Dependency of a function on Row Context in DAX
Antriksh Sharma
  • Nov 18, 2021
  • 4 min

Dependency of a function on Row Context in DAX

Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...
3610
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
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
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...
690
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
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.