How create the column PYDate?

[Isidro]

Hello,

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

[v-yuezhe-msft · Accepted solution]

@Isidro,

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,

[Isidro]

Hi @v-yuezhe-msft,

Thank you very much and best regards.