Challenges
Rolling 30-Day Revenue
advanced+150 XP
1 day
Concept:DATESINPERIOD
Objective
Create a measure 'Rolling 30 Days Revenue' using CALCULATE, [Total Revenue], and DATESINPERIOD starting from MAX(Date[Date]) for -30 days.
Required Functions:
CALCULATE()DATESINPERIOD()MAX()Illustrative visual preview
Filter Context:
π
Year = 2025π Country = Allπ·οΈ Segment = AllRolling 30-Day Revenue
β β β
Awaiting valid DAX formula check
Guided Hints
0 of 1 revealedfx
[fx]Rolling 30 Days Revenue=
Loading DAX Formula Studio...
Ctrl+Enter Checkβ’Ctrl+Shift+F Formatβ’Type [ for fields
Model
[fx]Total Revenue
[fx]Total Cost
[fx]Total Profit
[fx]Profit Margin %
[fx]Total Quantity
[fx]Total Orders
[fx]Customer Count
[fx]Average Order Value
[fx]Previous Year Revenue
[fx]YoY Revenue Growth %
πSaleID
π
Date
πCustomerID
πProductID
βQuantity
βRevenue
βCost
πCustomerID
AaCustomerName
AaCountry
AaSegment
Click field to copy syntaxDAX Active