© Philip Seamark, Thomas Martens 2019
P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_3

3. DAX Lineage

Philip Seamark1  and Thomas Martens2
(1)
UPPER HUTT, New Zealand
(2)
Hamburg, Hamburg, Germany
 

Introduction

A handy concept to learn when working with DAX calculations is the concept of lineage. DAX lineage refers to the ability to trace the heritage of data in table expressions back to original physical tables. When new table expressions get built by various DAX functions, the columns in the new table may contain a reference back to the original physical table from which it was initially derived.

Lineage information can also get used by the DAX query engine to help decide what the most optimal approach is to produce ...

Get Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.