Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PY Dax Formula no giving correct Values

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 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Worked out the solution

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Worked out the solution

 

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