Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way to optimize this measure?
Solved! Go to Solution.
I looked at this before @Vera_33 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 @Vera_33 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!
Hi @peterhui50
How about filtering the Year?
CALCULATE ([Items Sold],FILTER(DATE_TABLE, DATE_TABLE[Year]=YEAR(LASTDATE(DATE_TABLE[Date]))-1))