Period comparison measures

Pick a base measure and the comparisons you need, and get ready measures with formats and descriptions that go into your model in one script.

Base measureTable for the new measures

Date tableDate column

Fiscal year starts inAmount format

Names and descriptions in

Measure names

DescriptiveShort (YTD, PY)

Measures you need

The date table must be marked as a date table and contain every day with no gaps. You can create one with the date table generator. Date table generator

TMDL script (all measures at once)Individual measures

TMDL

Power BI Desktop: open TMDL view (icon on the left), paste the script into a new tab and choose Apply. The measures appear with formats, descriptions and their own folder.

Files are processed only in your browser and are never sent anywhere.