Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Converting US date/time text to EU date format

I receive a spread sheet each month from 3 different world areas. I store these in a Sharepoint folder and then combne them in PowerBi so that i end up with one global repprt.  The spreadsheets conta...
Need Help
Tips and Tricks
  • vicky_'s avatar
    vicky_
    3 years ago

    When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent. 
    After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).

     

vicky_'s avatar
vicky_
Super User
3 years ago

When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent. 
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).