Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Hi shashicr7,
PBI Report Server has some limitations. One limitation is with time intelligence functions. There are work arounds but I haven't figured it out yet. A key word search I'm using is 'advanced time intelligence' but I haven't found an exact solution yet. Sorry I couldn't help. The key here is you will find as I have that Report Server has some limitations with not accepting specific functions. There are work arounds but you have to research older publications before a function (for example SAMEPERIODLASTYEAR) was introduced. If I find anything I'll update this post.
Rich Ard
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
4 | |
3 |