Forum Discussion

paulphe's avatar
paulphe
Frequent Visitor
8 years ago
Solved

Lab 1: Exercise 2 for DAT207X edX Course

I am having an small problem here specifically in Step 4, bullet point 2; "Select to combine (combined binaries) the content of those 4 files, leave the default settings, and click OK." and bullet po...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    paulphe

     

    Hi, if you want to correct the dates you can do it in Query Editor, following these steps:

     


    Regards

     

    Victor

    Lima - Peru

     

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi paulphe,

     

    In this scenario, an alternative solution is to change the locale (the date and number formats) before importing the data. :smileyhappy:

    1. Go to File > Options and settings > Options.
    2. Under Current file, select Regional Settings.

    3. In the Locale box, select a proper locale.

    4. Select OK.

     

    Regards

  • BILASolution's avatar
    BILASolution
    8 years ago

    Hi again...

     

    Probably the problem appears after creating the new date column.

     

    After splitting the date column (wrong date column) by the delimiter "/", you get 3 columns (day, month and year) but the default data type is whole number, then whenever you try to concatenate again these columns, a error message appears. It's because before creating a new column you need to convert these 3 columns from whole number to Text.

     

    If the previous advice is not your case, try the next pbix file

     

    International Sales

     

     

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

Hi paulphe

 

Yes, you're right, the problem is the structure of the date, it must be "dd/mm/yyyy" instead "mm/dd/yyyy" (needs to be changed). Don't worry the excercise is been correctly solved.

 

paulphe's avatar
paulphe
Frequent Visitor
8 years ago

Great thanks for the confirmation.