Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How create the column PYDate?

Hello,   How create the column with the same date as the previous year?
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,


    Please check if the following DAX returns your expected result. If not, please share sample data of your column and post desired result here.

    PYDate = DATE(YEAR(Table[date])-1,MONTH(Table[date]),DAY(Table[date]))


    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,


Please check if the following DAX returns your expected result. If not, please share sample data of your column and post desired result here.

PYDate = DATE(YEAR(Table[date])-1,MONTH(Table[date]),DAY(Table[date]))


Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

     

    Thank you very much and best regards.