How create the column PYDate?

[Anonymous]

Hello,

How create the column with the same date as the previous year?

[Anonymous · Accepted solution]

@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]

Hi @Anonymous,

Thank you very much and best regards.