Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

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
0
Karen Schaefer
Asked:
Karen Schaefer
1 Solution
 
Zack BarresseCEOCommented:
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.

Regards,
Zack Barresse
0
 
Karen SchaeferAuthor Commented:
thanks, I found out in the editing of the script to change from datetime to date.  did the trick.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now