Prior year only display numbers for ytd periods

[PowerWhy]

Hello,

I have a table with current year and prior year columns. I have been asked to make the prior year column only display periods that we have in the current year (so that the total is year-to-date for both current year and prior year). Please can you tell me how to do this? The pbix file is at https://www.dropbox.com/s/10g30fzutd3m2z4/Test%20-%20only%20show%20YTD%20periods%20of%20prior%20fisc... 

(sorry I should have mocked this up for an incomplete quarter, but if this was a Fiscal Period 5 report then the Q2 total should be Period 4 + Period 5 (and ignore Period 6) for both current year and prior year)

PY Amount = calculate(sum(Actuals[Amount]),

    'Calendar'[Fiscal Year] = SELECTEDVALUE('Calendar'[Fiscal Year]) - 1

)

Thank you for your help,

PW

[amitchandak]

@PowerWhy , You need to have a measure like

calculate(sum(Actuals[Amount]), Dateadd('Calendar'[Date],  - 1, year)
)

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s