🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate37 / 150
Question 37 of 150
You are building a semantic model in Fabric with a fact table Sales and a marked Date table. Business users want a measure that compares the current visual's quarter total against the total from three quarters earlier, regardless of how the visual is sorted or which quarters are visible. You want to use the DAX window functions introduced for this purpose rather than classic time-intelligence functions. Which DAX function is the most appropriate core of this measure?
Reviewed for accuracy · Report an issueNext question