Forum Discussion
Helper ICalender Creation
Hi Guys. I created a Calender measure however the type icon for this calender is different than the usual one
Below is how I set up the measure and it should be correct since my other database were using this same measure and they working perfectly.
How can I set up calender correctly so I can create hierarchy out of it?
Thanks in advance
It's not a measure (i hope), it's a table. The icon represents a primary key and I think that's what happens when you mark the table as a date table. Reasonably sure you have to create the hierarchy yourself if you do this (create year, month , day columns then create the hierarchy).
If you unmark the table as a date table, the icon will change and the hierarchy will be there (That's me doing this from memory)
Let me know how you get on
1 Reply
- HotChilli
Community Champion
It's not a measure (i hope), it's a table. The icon represents a primary key and I think that's what happens when you mark the table as a date table. Reasonably sure you have to create the hierarchy yourself if you do this (create year, month , day columns then create the hierarchy).
If you unmark the table as a date table, the icon will change and the hierarchy will be there (That's me doing this from memory)
Let me know how you get on