Forum Discussion
Months in wrong order
Open the attached file. I created a dummy table "Sales", then created the Calendar table like I told you, then created the relationship and you'll see the date hierarchy on the Calendar Table.
Do you have a Calendar table? Could you send a print of the field list (on the right)?
OK, so you should add a Calendar table first, clik "Add Table" and write like:
Table Name = CALENDAR (FIRSTDATE(Reference to date formatted column in data source),LASTDATE(Reference to date formatted column in data source))
Then you should connect the date on the Table you created with the date on the Fact table.
From now on you'll use the date table for everything (calculations, fields on visuals, etc.).
There will probably be a new Date Hierarchy on the new Date Table, if there isn't, create it (right click...).
After this you'll have Year, Quarter, Month and Day fields and the sorting is always good.
thank you for your answer. I tried to fill in the right dates but I can't seem to get it.
I have a colum in excel with Year and Month. which is 2018 and the months in text: june, july, august..
What do I need to fill in?
