PY Dax Formula no giving correct Values

[Anonymous]

Hi Experts

Its driving me mad I cannot get the PY values from my Sales table and populate then into my table and dynamically check this values based on my filters.

Sample data 

[Anonymous · Accepted solution]

Worked out the solution

PY = calculate([ACT],dateAdd('Calender'[Date],-1,YEAR)