User Profile
shashicr7
Regular Visitor
Joined 6 years ago
User Widgets
Contributions
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)571Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.