Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Worked out the solution

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Worked out the solution

     

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