The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |