BestPracticeRules icon indicating copy to clipboard operation
BestPracticeRules copied to clipboard

[Rule request] Avoid sideways recursion

Open otykier opened this issue 4 years ago • 1 comments

A rule that detects if a calculation item expression holds references the calculation group itself in the DAX expression (this indicates a sideways recursion which should be avoided).

otykier avatar Jul 20 '20 18:07 otykier

What is the rationale for avoiding sideways recursion? Microsoft seems to suggest that this would be the typical way of defining a YOY or YOY% calculation item. https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#sideways-recursion

ruve1k avatar May 13 '21 17:05 ruve1k