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