Goal: Calculate a Rolling 3-Month Total.
Watch the "Window" slide down, capturing the current month + previous 2 months.
Ready...
💻 DAX Formula
-- Scenario: Rolling 3-Month Total
MEASURE Rolling_3M =
CALCULATE (
SUM( Sales[Amount] ),
DATESINPERIOD (
'Date'[Date],
MAX('Date'[Date]), -- End Date (Current Row)
-3, MONTH -- Go back 3 months
)
)