Category Archives: DAX

FILTER Functions for Power BI in DAX – Overview

FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions as is nested parameter and enable dynamic calculations. They often serve as a value filter for function  CALCULATE. Mostly it is the case of typical member… Read More »

Aggregation in DAX – How Aggregations Work? + Function Overview

Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into more simple and reportable form using aggregation. We can for example sum up (SUM, SUMX) some financial metrics by individual category or express maximal/minimal (MAX, MAXX,… Read More »

Function DAX CALCULATE – Aggregation With a Condition in Power BI

CALCULATE is an important function for a large number of calculations and for those of you who actively do DAX formulas in Power BI or PowerPivot. Understanding of how the function works and how it is used does not look simple at first glance. And that is why this article is here. Syntax function: CALCULATE(… Read More »

DAX RELATED Function for Power BI – Lookup Into Table

Function REALTED is very frequent and useful in DAX language. We can use it for example when we need to search table (A) for value from other table (B). And finding the according value is the exact task of this function. Syntax is very simple: How Come RELATED Function Needs Only 1 Parameter? Data organization… Read More »

DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI

You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing. Some aggregate functions have another similar function ending with X – for example SUM and SUMX or COUNT and COUNTX. These functions often give same results… Read More »

DAX Difference Between Measure and Column + Example on Report

We can create two types of new values using DAX in Power BI or PowerPivot. They are calculated measures and columns. Difference between measure and column and its understanding is another major step in order to understand DAX language for Power BI. New measure or column in Power BI is added by clicking right mouse… Read More »

DAX language – Introduction into DAX for Power BI and Powerpivot

DAX language (Data Analysis Expressions) servers for data management and editing prior reporting in Power BI or Powerpivot, similarly to function set in Excel. This language is able to return values based on use of functions. We can either enrich, add or analyze data prior reporting in Excel, and DAX enables us to do the same.… Read More »

Parameters in DAX – Introduction into DAX Expressions

DAX language haves its standards as does any other language. This article sums up and describes how look the parameters of formulas. In other words, this article is about function arguments overview.  It is good to know parameter categories appearing in this language to effectively use parameters in DAX. What is Function Parameter in DAX?… Read More »