Forum Discussion

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
4 years ago
Solved

Calender 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 da...
  • HotChilli's avatar
    HotChilli
    4 years ago

    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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

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