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.
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?
Calender = CALENDAR(FIRSTDATE('FactTable'[Date]);LASTDATE(FactTable'[Date]))Change the name of table and column. This way you have a dynamic Calendar Table always depending on Fact table, which is the recommended way.
I only get errors. This is my data. So what do I need to fill in after FIRSTDATE(. Because I get errors if I fill in dates like 1, 8, 2018 and I get errors if I fill in Juni, 2018. So I don't get it. Do I need to make other tables in excel first?