AnonymousNot applicable9 years agoSolvedHow create the column PYDate?Hello, How create the column with the same date as the previous year?Anonymous9 years agoAnonymous, 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,
Anonymous9 years agoAnonymous, 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,
Anonymous9 years agoAnonymous, 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,
2 RepliesReplies sorted by Most LikedAnonymousNot applicable9 years agoAnonymous, 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,AnonymousNot applicable to Anonymous9 years agoHi Anonymous, Thank you very much and best regards.
AnonymousNot applicable9 years agoAnonymous, 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,
Related contentCreate columns groupCreating a date columnCreating a custom columnunpivoting columns and creating datetime columncreate custom column concatenated
