Build Relative-Time Measures in Three Steps

Measures such as year-to-date, previous year and rolling periods are easier to maintain when their calendar rules are modeled centrally.

Practical approach

Start with a trustworthy date dimension or date attributes, define the relevant relative-time expressions and expose the resulting measures to reports and dashboards.

Validation and limitations

Validate fiscal calendars, incomplete periods and year boundaries with real examples.

Read the German original

AI-assisted translation and adaptation.