Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have 2 measures, where depending on the date filters selected, I show:
Last 12 months:
CALCULATE
(
[Xyz] , DATESINPERIOD ( 'Date'[Date] , MAX('Date'[Date]) , -12 , MONTH )
)
I need to do the same, but for months -12 to -24.
I have tried, but DATEADD doesn’t seem to work with MAX…
var dat = MAX('Date'[Date])
RETURN
CALCULATE
(
[Xyz] ,
DATESINPERIOD(
'Date'[Date],
DATEADD(dat,-12,MONTH) ,-24,MONTH)
)
How can I make the period from -12 to -24 ?
@ovonel , Try like
Rolling 12 till last 12 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],maxX(Sales, dateadd(Sales[Sales Date],-12,month)),-12,MONTH))
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |