Date Format ( European to American ) Issue

Date Format ( European to American ) IssueFollow
Ganesh Kumar
Ganesh KumarSep 29, 2022 06:48 AM
Hi All, I am getting date format issue in my report, my source data in European date format and data …
1. Date Format ( European to American ) Issue

Silver Contributor
Ganesh Kumar
Posted Sep 29, 2022 06:48 AM | view attached (2)
Hi All,

I am getting date format issue in my report, my source data in European date format and data type is in text, so I am trying to convert that into American date format and getting error. below are query i used to convert ,

=Text.BeforeDelimiter(Text.AfterDelimiter([Created Date],”-“),”-“) &”/”&
Text.BeforeDelimiter([Created Date],”-) &”/”&
Text.BeforeDelimiter(Text.AfterDelimiter(Text.AfterDelimiter([Created Date],”-“),”-“),” “)

after converting into American date format I selected data type as date. whenever i do refresh am getting error, could please help me on this. attached sample file for your reference.

——————————
Ganesh Kumar
Analyst
——————————
Attachment(s)

pbixDate Format.pbix
xlsxdata.xlsx

2. RE: Date Format ( European to American ) Issue

Bronze Contributor
James Watts
Posted Oct 05, 2022 03:44 AM
The problem is that you have different date formats in your spreadsheet.
E.g.

row 30154 29-04-2022 10:16:08
row 30157 03/05/2022 10:16:25
row 31736 04-01-2021 08:03:54 AM

You either need to add a processing step to reduce them all to one format, or correct your source data.

——————————
James Watts
Business Intelligence Analyst
——————————

3. RE: Date Format ( European to American ) Issue

Top Contributor
Mahesh Caroicar
Posted Oct 06, 2022 12:45 PM
I’ve used your Report and Data, I’ve made some changes in Power Query with the Using Locale Data type and it worked just fine, let me know if you made it

Mahesh

——————————
Mahesh Caroicar
IT Consultant
Santiago
Chile
——————————

4. RE: Date Format ( European to American ) Issue

Silver Contributor
Ganesh Kumar
Posted Oct 06, 2022 12:53 PM
Hi @Mahesh Caroicar,

Thank for the information, could you please share the file you worked to me i can understand more.​

——————————
Ganesh Kumar
Analyst
——————————

5. RE: Date Format ( European to American ) Issue

Top Contributor
Mahesh Caroicar
Posted Oct 06, 2022 01:02 PM | view attached
Sure!!, please make sure to Change the Source Path since the attached file is pointing to my computer’s disk path

——————————
Mahesh Caroicar
IT Consultant
Santiago
Chile
——————————

Attachment(s)

pbixDate FormatChanged.pbix