Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
vanessa
Post Patron
Post Patron

Error with SAMEPERIODLASTYEAR: an invalid numeric representation of a date value was encountered

‎11-13-2017 05:57 AM

I have created a metric to calculate the sales for last year.

Below is the formula:

LastYear_Sales = CALCULATE(SUM('Fact_Sales'[SALES_AMT]),SAMEPERIODLASTYEAR('Dim_Day'[Date]))

 

when I create a table with: Date from Dim_Day and LastYear_Sales, I get the following error:

DAX_Error.png

Labels:
Message 1 of 7
4,986 Views
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

‎11-14-2017 12:44 AM

@vanessa,

 

Based on my test, this can be caused by an invalid datetime value that exceeds the year 9999.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 7 of 7
5,215 Views
0
6 REPLIES 6
v-chuncz-msft
Community Support
Community Support

‎11-14-2017 12:44 AM

@vanessa,

 

Based on my test, this can be caused by an invalid datetime value that exceeds the year 9999.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 7 of 7
5,216 Views
0
Greg_Deckler
Super User
Super User

‎11-13-2017 06:45 AM

Seems like it does not like your [Date] column. Is it flagged as a numeric field in the data model?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 7
4,972 Views
0
vanessa
Post Patron
Post Patron
In response to Greg_Deckler

‎11-13-2017 07:01 AM

I checked that. It is a date/time field.

 

Message 3 of 7
4,970 Views
0
Greg_Deckler
Super User
Super User
In response to vanessa

‎11-13-2017 07:50 AM

Hmm, reading the error more closely, it says MdxScript, is this a Live data source? (DirectQuery)

 

That function is not supported in DirectQuery mode.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Message 4 of 7
4,967 Views
0
vanessa
Post Patron
Post Patron
In response to Greg_Deckler

‎11-13-2017 09:22 PM

I am using Import mode to fetch data from MySQL.

Message 5 of 7
4,954 Views
0
SivaMani
Resident Rockstar
Resident Rockstar
In response to vanessa

‎11-13-2017 09:38 PM

@vanessa,

 

 

 

Could please share the sample data?

 

It would be helpful to assist.

 

Message 6 of 7
4,951 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All