calculate selected year stock and last year

[Wadda7AboUdai]

Hello Everyone 

I have  this measure to get the stock for the selected year in filter 

Selected Year = CALCULATE(SUM(GENERALJOURNALS[AMOUNT]),FILTER(GENERALJOURNALS,GENERALJOURNALS[MAINACCOUNT] = 5637144608))

Now I want to create  measure shows the stock  for last year of selected year, for example 

If the selected year was 2022 the colum3 should calculate data for 2021 , If the selected year was 2021 the column 3 

should calculate data for 2020 and so on , I hope I could explain what I need 

[BA_Pete · Accepted solution]

Hi @Wadda7AboUdai ,

Create a calendar table and relate it to your fact table on Calendar[Date] ONE : MANY Fact[Date], then use the following measure:

_PriorYear =
CALCULATE(
    [Selected Year],
    SAMEPERIODLASTYEAR(Calendar[Date])
)

Pete