PowerPivot -Query Editor - Convert Date

How do I prevent the date value from being converted back to a Serial when Power Query creates the Pivot Data.

IE.  7/1/2014 - 45323

This is using the Power Query tool within Excel
Karen SchaeferAsked:
Who is Participating?
Zack BarresseConnect With a Mentor CEOCommented:
Hi there,

I don't have that happen. Not sure how you did yours, but right-click the column in the Query Editor (Power Query), select Change Type, choose Decimal or Number, depending on if you need to keep a time value. Works for me when loaded to a data model.

Zack Barresse
Karen SchaeferAuthor Commented:
thanks, I found out in the editing of the script to change from datetime to date.  did the trick.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.