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...
techies
Super User
Super UserRolling 52 Weeks Sales =
CALCULATE(
[sales],
DATESINPERIOD(
'Date'[Date],
MAX('Date'[Date]),
-365,
DAY
),
VALUES('Date'[Weeknum])
)