Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shashicr7
Regular Visitor

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)

 
1 REPLY 1
DAXRichArd
Resolver I
Resolver I

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.