Hi
Can' find a solution to this date problem. Please help if you found one.
The date column in the excel data file is formatted as dd.mm.yyyy but by the time it gets into the PowerPivot (as linked table) the format of the date change form some of the dates.
In PowerPivot dates as 12.11.2013 (11-Nov) are changed to 11.12.2013 (11-Dec) but dates as 13.11.2014 remains 13.11.2014.
Basically if the day in may excel table exceed 12 PowerPivot will get the date right, but if the day it's under 12 will replace the day in my table with month in powerpivot window and I have no idea why.
Any help would be appreciated.
Thanks
Bookmarks