Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need assistance for how to create a measure that Looksback 364 days then does an aggregate of the previous 364 days on Custom Calendar Dimension.I created the measures separately but I'm unsure how to combine them, or if it needs written a different way.
Sales Last Year:= CALCULATE([Sales],DATEADD('Calendar - Fiscal'[Date],-364,DAY))
Sales 364 day Agg:= CALCULATE ( [Sales], DATESINPERIOD ( 'Calendar - Fiscal'[Date], LASTDATE ( 'Calendar - Fiscal'[Date] ), -364, DAY ) )
Below is an example of the data I want to lookback on then aggregate. Any help would be appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |