Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

My CSV file Posting Date how to convert to Date ?

Hi All

 

I have a CSV file , the posting date , after import to PQ , i try to convert it to Date , all date become error. i also try to convert to US date , it also not working. Hope you can help me to import to PBI , and let me know how to make it become date ?

https://www.dropbox.com/s/1326cuvkjirs9co/GL_TS.csv?dl=0

I Try by import using CSV file format.

Paul

1 ACCEPTED SOLUTION
v-zhenbw-msft
Community Support
Community Support

Hello @Paulyeo11 ,

Maybe the structure of your date can't change to the U.S. date.

You must right-click the date column and select Change Type -> Using Locale.

M1.jpg

Then choose English (World).

M2.jpg

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

4 REPLIES 4
v-zhenbw-msft
Community Support
Community Support

Hello @Paulyeo11 ,

Maybe the structure of your date can't change to the U.S. date.

You must right-click the date column and select Change Type -> Using Locale.

M1.jpg

Then choose English (World).

M2.jpg

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

Hi Zhen

Thank you vry much for your sharing , yes you are correct , i make a mistake to change the date to USA date , which is wrong . instead i should use UK date .

If this world all just using one standard date , i think it will be less problem , but that is not possible.

Paul 

Ashish_Mathur
Super User
Super User

Hi,

It imports just fine for me.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ash

thank you for sharing , I will try again . 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.