DAX

Creating a Table in Power BI Using DAX Table Constructor

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days...

read more

Creating a Table in Power BI Using DAX Table Constructor

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days...

read more

REMOVEFILTERS() in DAX

Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as a table filter parameter inside CALCULATE() as shown in...

read more

Naming temporary columns in DAX

Table functions in DAX expressions can create temporary columns that are not tied to any column in the model. Temporary columns do not filter any column in the filter context unless you use TREATAS (see data lineage described in a previous article), so a standard...

read more

Custom Sort Order Within a DAX Measure

Custom Sort in DAXThis post will answer how to sort a measure that returns text values to a custom order, without affecting other columns. It will utilize the DAX functions of REPT() and UNICHAR(8203) - a Zero width space. The requirements I've been working at a...

read more

Free Webinar: Introduction to DAX for Power BI

On 2 October I will be hosting a free webinar called "Introduction to DAX for Power BI". I have trained literally thousands of people on the DAX language through my books, online training and live training. But everyone is on their own learning journey and there are...

read more

Some Methods for Calculating Quarter in DAX for Power BI

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start...

read more

Blank row in DAX

DAX offers two functions to retrieve the list of values of a column: VALUES and DISTINCT. The difference between the two is subtle. To understand it better, we first need to introduce the concept of the blank row. The blank row is a special row added to a table, in...

read more

The Definitive Guide to DAX – 2nd Edition

The Definitive Guide to DAX (Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI) is the most comprehensive and authoritative guide to Microsoft's DAX language for business intelligence and analytics. While other...

read more
Share This