TabularEditor / BestPracticeRules

An official collection of standard Rules for use with Tabular Editor's Best Practice Analyzer.
120 stars 53 forks source link

[Rule request] Avoid sideways recursion #35

Open otykier opened 4 years ago

otykier commented 4 years ago

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).

ruve1k commented 3 years ago

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