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.
However, as a Collibra Admin, you can 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.
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 data consumers 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 analysis via Collibra AI.