🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate26 / 150
Question 26 of 150
You are building a semantic model with a Sales fact table and a Date dimension marked as the date table. Business users need a measure that returns the rolling 12-month average of total sales, recalculated for whatever month is in filter context. The measure must divide the sum of sales over the trailing 12 months by 12. Which DAX expression correctly implements this?
Reviewed for accuracy · Report an issueNext question