Forum Discussion
Rolling 52 weeks.
Hi all, I want to create this visual in PBI for our [sales] measure (pretend that w.2 is last week and for 52 weeks. So, one line to show the sales rolling 52 weeks and one to show the same p...
Hi,
techies
Super User
Super UserHi there mrclay823
Have you tried this?
Rolling 52 Weeks Sales =
CALCULATE(
[sales],
FILTER(
ALLSELECTED('date'),
YEAR('date'[Date]) = YEAR(MAX('date'[Date])) &&
'date'[Weeknum] <= WEEKNUM(MAX('date'[Date])) &&
'date'[Weeknum] > WEEKNUM(MAX('date'[Date])) - 52
),
ALLEXCEPT('date', 'date'[Year])
)