Menu

1 / 14

Explaining Lineage in DAX | Towards Data Science

#towardsdatascience#date#order#count#product
Reading 0:00
15s threshold

Introduction

In DAX, lineage is an important concept, and it is vital to understand how to work with and manipulate it.

As I did in past articles, I will use DAX queries to explain this concept and its effects.

I start with a simple query to get the order count for the product of the brand “Adventure Works”:

EVALUATE CALCULATETABLE( SUMMARIZECOLUMNS('Date'[Year] ,'Date'[MonthShortName] ,'Date'[MonthKey] ,'Product'[ProductCategoryName] ,"Order Count", [Online Order Count] ) ,'Product'[BrandName] = "Adventure Works" ) ORDER BY 'Date'[MonthKey] ,'Product'[ProductCategoryName]

This is an extract of the result from the query:

Figure 1 – Result of the base query (Figure by the Author)

This query returns 180 rows.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.