Forum Discussion
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...
Hi paulphe,
In this scenario, an alternative solution is to change the locale (the date and number formats) before importing the data. :smileyhappy:
- Go to File > Options and settings > Options.
- Under Current file, select Regional Settings.
-
In the Locale box, select a proper locale.
-
Select OK.
Regards
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
