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

3. DAX Lineage

Philip Seamark and Thomas Martens2
UPPER HUTT, New Zealand
Hamburg, Hamburg, Germany


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 ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.