Q: 3
HOTSPOT
You need to create a DAX measure to calculate the average overall satisfaction score.
How should you complete the DAX code? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Your Answer
Discussion
Noticed a lot of us are split on whether "number of months" means a rolling period or a fixed one. Did the question actually show any filter context hint, like a time slicer? Without that, I'd assume they want the rolling window, so that'd be DAX with DATESINPERIOD. Am I missing something obvious?
Its D, pretty sure. In these Fabric DP-600 scenarios, AVERAGE with DATESINPERIOD on the satisfaction column is usually the pattern for rolling averages. Only thing I'm not totally certain about is if 'number of months' can change or if it's always a fixed window (like 12). If anyone’s seen otherwise let me know.
Option D Saw similar on official guide and labs, AVERAGE and DATESINPERIOD usually used for this.
Be respectful. No spam.
