In the DAX Rolling 12 Overall Satisfaction measure, which term should replace <ANSWER HERE> to apply the 12-month period filter?

• A. LastCurrentDate
• B. NumberofMonths
• C. Period
• D. data

Answer: (C)

Rolling time filters in DAX hinge on referencing a date-related window, not a single date or a numeric value. When you want a 12-month rolling view, you apply a filter that covers the last 12 months from the current date context. Replacing the placeholder with Period ties the measure to the date dimension's period representation, so the filter automatically constrains data to the 12-month window defined by that period. This makes the calculation respond to the true rolling window across all relevant months.

LastCurrentDate would point to a single date, which doesn’t create a 12-month span. NumberofMonths is a numeric parameter, not a table or column you can filter on. data is too generic and doesn’t specify a time period. Period is the right construct to anchor the rolling 12-month filter to your date dimension.