Forum Discussion
Solved
Optimize a measure?
Is there a way to optimize this measure? Items_Sold__Rolling_12_Months__Last_Year = CALCULATE ([Items Sold], SAMEPERIODLASTYEAR ( DATESINPERIOD ( DATE_TABLE[Date], LASTDATE ( DATE_TABLE[Date...
I looked at this before Anonymous posted a reply...
Try this
ItemsSoldRolling12MonthsLastYear = CALCULATE( [ItemsSold], PREVIOUSYEAR(DATE_TABLE[Date])) )This requires you have a date table and that it's marked appropriately. Hope this helps!
I looked at this before Anonymous posted a reply...
Try this
ItemsSoldRolling12MonthsLastYear =
CALCULATE(
[ItemsSold],
PREVIOUSYEAR(DATE_TABLE[Date]))
)This requires you have a date table and that it's marked appropriately. Hope this helps!
peterhui50 how are Anonymous and my solutions looking? 😉