Data Analysis Expressions (DAX) is a programming language that is used in Power BI for creating calculated columns, measures and custom tables.
Power BI columns that are derived from DAX are shown in the technical lineage. However, Collibra Data Lineage is unable to parse DAX. Therefore, stitching between calculated columns in the technical lineage and the corresponding Power BI Column assets in Data Catalog is not possible.
You can, however, show DAX calculations for calculated columns and measures on Power BI Column asset pages. All elements in the DAX, even comments for example, are included and shown in the Calculation Rule attribute.
Note The Calculation Rule attribute type is part of the global assignment of the Power BI Column asset type and cannot be deleted.
The following additional information on Power BI Column asset pages can also help you interpret the lineage:
- If a calculated column is a measure, the Role in Report attribute has the value "Measure".
- The Technical Data Type attribute indicates the type of column, for example "String" or "Number".
- Creates column-level lineage that includes your calculated columns and measures in Power BI.
- Enables stitching between calculated columns in the technical lineage and the corresponding Power BI Column assets in Data Catalog.
For complete information, go to DAX parsing via Collibra AI.