DAX Formatter & Measure Builder
Clean up messy DAX and generate the standard time-intelligence measures — YTD, MTD, previous year, YoY %, and moving averages — for your Power BI model.
Tool interface
Result
Ready.
Introduction
Time-intelligence measures follow predictable patterns. This tool generates them correctly from your base measure and date column.
Limitations
- Assumes a single, contiguous, marked date table.
- Custom fiscal calendars need manual adjustment.
FAQ
Why does YTD return blank?
Usually the date table is not marked as a date table, or the relationship is inactive.