Forum Discussion

surajbh's avatar
surajbh
Icon for Helper I rankHelper I
3 years ago
Solved

Different Date format- dd/mm/YYYY and dd.mm.YYYY

I have different date format ( dd.mm.YYYY and dd-mm-YYYY ) in the source file at the same column- Date, and would like to convert those different format into a single format of Date on powerquery.  ...
Need Help
  • surajbh's avatar
    surajbh
    3 years ago

    i could manage with further google, to change the setting of power bi- now it works. 
    thanks for the direction- was helpful,

     

    Thanks.

     

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi, I think this Global regional settings will work only for import mode but mine is direct query mode. My issue is date is in text format in dd-mm-yyyy format in tabular cube and in power bi report it is showing as dd-mm-yyyy format but when i export to excel few dates are displayed as dd-mm-yyyy format and few in dd/mm/yyyy format, can someone please help?

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
10 months ago

Excel is interpreting some of the dates as real dates and others as text strings. This is usually due to a mismatch between the date format and your Excel windows date settings. During the import process, you will need to tell excel the format of the incoming dates, BEFORE it converts them.

 

How exactly are you exporting to Excel? If it is a CSV file, then IMPORT it into Excel using either Power Query or the Legacy Import Wizard, and be sure to tell the legacy import tool that your incoming csv has dates in DMY format (or use the optional culture argument in the step in Power Query where you first set the data types).