Calender Creation

[njxfoster]

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

[HotChilli · Accepted solution]

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