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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Switto
Helper III
Helper III

Date format issue

Hi,

I have multiple date columns coming from SP as "Fri Nov 19 2021 19:31:44 GMT+0530 (India Standard Time)" this format and while converting into date, it is showing error. Any idea how to convert it ?

Thanks in advance ,

Switto

1 ACCEPTED SOLUTION
Switto
Helper III
Helper III

Hi All, We did some research and tried the option "Extract" and than "Range"  in Add column in Power query  as the data is same in all rows and worked fine. 

View solution in original post

5 REPLIES 5
Tahreem24
Super User
Super User

@Switto , Follow the below steps:

 

Step 1: Go to Power Query Editor

Step 2: Select your Date column and right click on it and select Split column 

Step1.JPG

Step 3: Enter 15 like below and choose the first option

Step2.JPG

Step 4: You'll get the answer in the first column like this:

Step3.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Switto
Helper III
Helper III

Hi All, We did some research and tried the option "Extract" and than "Range"  in Add column in Power query  as the data is same in all rows and worked fine. 

SanketBhagwat
Solution Sage
Solution Sage

Hi @Switto .
If it's data format is text, then you can't directly convert it to a date format.
Which mode did you use to import the file into your Power BI desktop?
You will need to change your format from there only.


Regards,
Sanket 

If this post helps you give it a 👍 and if it solved your issue consider Accept it as the solution.

@SanketBhagwat , Thanks for the quick reply. As it is an online ShrePoint list, I have connected data through SP Online list option.

 

Okay.
Then I would advise you to change its format in the Share Point list.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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