All checks
Structural and report checksMaintainabilityLow

Calculated columns without explicit type

"Calculated columns without explicit type" is one of the maintainability checks Auditabi runs on a Power BI semantic model. Calculated columns have no explicit data type, so the engine infers one from the expression. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Set the data type and format string of every calculated column explicitly.

What is detected

Calculated columns have no explicit data type, so the engine infers one from the expression. A change in the expression can silently turn a number into text and break every visual that uses it.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Set the data type and format string of every calculated column explicitly.

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More Structural and report checks checks