Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Which measure correctly calculates Year-over-Year percentage growth?
DIVIDE([Total Sales] - [PY Sales], [PY Sales])
[Total Sales] / [PY Sales], although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
[Total Sales] - [PY Sales], however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.
CALCULATE([Total Sales], DATEADD('Date'[Date], -1, YEAR)), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
A syntax-level statement that appears valid but actually describes iterator usage in a context where scalar evaluation is required
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!