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.
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?
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.