Error in creating last year sales measure using SAMEPERIODLASTYEAR function.
Hi, I have a measure LY Sales = CALCULATE([Sales_Amount Measure], SAMEPERIODLASTYEAR('PDW_DATE_D'[CAL_DATE])) but is giving the following error: An invalid numeric representation of date value was encountered. also,column CAL_DATE is of datatype:Date (example : 2019-01-07)