Power Pivot Date Query

G

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
767
Office Version
  1. 365
Platform
  1. Windows
Good afternoon,

I have imported a file in to Power Pivot for interrogation, but I have found an issue.
When I have uploaded the file the date format has come through as "YYYY-MM-DD" as text and I cant work out how to change this to "DD/MM/YYYY" for the "lookupvalue" and other formuals.

Any ideas as I have tried a few different things, but when the format has completed it always shows as text

thanks
Gavin
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Similar threads

W
  • Question
Date conversion
Replies
2
Views
115
GraH
GraH
M
  • Question
Power Query imports date as number and is off by 4 years and one day
Replies
1
Views
119
KRice
K
C
  • Question
Power Query Date and Text
Replies
1
Views
162
RoryA
RoryA
BrettOlbrys1
  • Question
Power Query Issue
Replies
1
Views
258
Matt Allington
M
I
  • Question
PowerPivot: calculate previous year value if date formatted as text
Replies
3
Views
92
Matt Allington
M

Forum statistics

Threads
1,214,620
Messages
6,120,559
Members
448,970
Latest member
kennimack

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top