Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SAMEPERIODLASTYEAR in a Calculated Column

Hi, I need the Sales Last Year (Sales LY) as a Calculated Column in my Data Base so I can compare Sales vs Sales LY in a Scatter Chart by Peer. My problem is that when I apply the SAMEPERIODLASTYEA...
Need Help
Tahreem24's avatar
Tahreem24
Super User
6 years ago

You could also try the below :

CALCULATE ( SUM(Append1[Value]),
DATEADD(Append1[Date], -1,YEAR))
or
CALCULATE ( SUM(Append1[Value]),
ParallelPeriod(Append1[Date], -1,YEAR))