TMDL calculation group · €29
DAX time intelligence pack
Apply consistent time comparisons to additive measures.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- Explicit measures and a related full-year date table named Calendar[Date].
- Your result
- 12 calculation items including MTD, YTD, prior year and monthly rolling average.
- What you need
- Power BI Desktop with TMDL view. All 12 items passed for one month on the supplied data; prior-year items were only checked as BLANK without prior-year data. Test on a copy.
- Check this first
- Fiscal YTD assumes 31 March until changed. Validate percentages, balances and distinct counts separately.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
TimeIntelligence_TMDLview.tmdlon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
Read Library Guide chapter 7, adapt the date-table name and fiscal year end, then apply in TMDL view on a copy.
Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.