Forum Discussion
Solved
Months in wrong order
Hello, I need help with a subject. I have a few KPI's which are numbers, a target which is a number and the months. If I make a cauge I can select the current month, july. But if I make a KPI...
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.