Solved: How create the column PYDate?

Anonymous · ‎06-15-2017

Hello,

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

v-yuezhe-msft · ‎06-18-2017

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuezhe-msft · ‎06-18-2017

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.