Forum Discussion

kennyyip's avatar
kennyyip
Helper I
8 years ago
Solved

Maintain date hierachy with date table

Hi, I have a data set "revenue" with revenue and date (only month end date involved but it's still down to day level). To use datesadd and tablesytd function I created a date table "Calendar" with ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

The relatioship from revenue[date] to calendar[date] should be a many to one relationship.  In the visual, drag Date from the Calendar Table.

kennyyip's avatar
kennyyip
Helper I
8 years ago
Sorry, my bad to describe not accurately. You are right it's one to many from Calendar to Revenue. But I still couldn't get the date hierachy after relating both
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    I always follow the best practise of creating Year and Month columns in the Calendar table and then dragging those to the visuals.