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...
820
Storing a column as String or Integer in Analysis Services
Antriksh Sharma
  • Dec 20, 2021
  • 2 min

Storing a column as String or Integer in Analysis Services

Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...
980
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,...
3560
How to extract measures from Power BI to Excel or Text file?
Antriksh Sharma
  • Sep 26, 2021
  • 3 min

How to extract measures from Power BI to Excel or Text file?

A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...
1340
SUM vs SUMX in DAX
Antriksh Sharma
  • Sep 1, 2021
  • 4 min

SUM vs SUMX in DAX

SUM and SUMX are both aggregation functions in DAX. While SUM allows you to aggregate only one Physical column of a table, SUMX is more...
2170
How to Load Data From Power BI into SQL Server?
Antriksh Sharma
  • Jul 23, 2021
  • 2 min

How to Load Data From Power BI into SQL Server?

Whenever I work with LinkedIn data challenges a very common task for me is to load data into SQL Server as modifying the data in SQL is...
1300
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...
4790
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...
550
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,4050
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...
590
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...
1,9590
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...
430
DAX Studio: Building Queries Manually (Using UI)
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,...
340
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.