How create the column PYDate?

[Anonymous]

Hello,

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

[v-yuezhe-msft · 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 @v-yuezhe-msft,

Thank you very much and best regards.