Question

You maintain a Power BI model with 12 base measures (Total Sales, Total Cost, Total Profit, etc.). Business users want each measure to be viewable as Current, Year-to-Date (YTD), Prior Year, and Year-over-Year % without you creating 48 separate measures. You want a maintainable solution that applies these time-intelligence variations to any measure a user places on a visual. Which modeling feature should you implement?

Accepted Answer

Create a calculation group with calculation items for Current, YTD, Prior Year, and YoY % using SELECTEDMEASURE()

Answer

Create 48 explicit DAX measures, one for each combination of base measure and time variation

Answer

Add a role-playing date dimension and duplicate the model relationships for each time period

Answer

Create a field parameter that lists all 12 base measures so users can swap them on visuals