Several date columns on a fact with a single relationship
"Several date columns on a fact with a single relationship" is one of the modeling checks Auditabi runs on a Power BI semantic model. n fact table(s) carry three or more date columns but only one relationship to the date table. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Add inactive relationships for the other date roles and expose them through measures with USERELATIONSHIP, or duplicate the date table for the second role.
What is detected
n fact table(s) carry three or more date columns but only one relationship to the date table. The other dates cannot be analysed without rebuilding a filter by hand.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Add inactive relationships for the other date roles and expose them through measures with USERELATIONSHIP, or duplicate the date table for the second role.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.