mrclay823New Member1 year agoRolling 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...Show More
techiesSuper User1 year agoHi mrclay823 Rolling 52 Weeks Sales = CALCULATE( [sales], DATESINPERIOD( 'Date'[Date], MAX('Date'[Date]), -365, DAY ), VALUES('Date'[Weeknum]) )
Related contentCalculating rolling 52 weeksRolling 52 for Yesterdays day of the weekRolling 52 week sales and preceding 52 week salesRolling 2 week, 4 week average4 / 13/ 52 Week Rolling Averages
