Forum Discussion

mwen90's avatar
mwen90
Helper III
5 years ago

31 date columns

Hi, 

 

I have a table, which has 62 columns. 1 column is a date column, the other is a value for that day.

 

How can I build a relationship for date between all the date columns? I have a date table, but because its only linked to one column, I am only getting the data for all dates on the 1st of the month. I can't get anything else,

 

Thanks for the help!

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi mwen90 

    Are you saying you have 31 columns containing dates in your fact table?  If so,why do you have this?

    Normally you would just have a single date or datetime column and then relate that to the date table. In the date table you would then have different columns for things like day of week, day of month, month,month name, quarter etc etc and that's how you slice the data according to the granularity defined in the Date Table columns.

    regards

    Phil

  • mwen90's avatar
    mwen90
    Helper III
    5 years ago

    PhilipTreacy  thanks for getting back to me. 

     

    Not sure it was the way the data was given to me in an excel.

     

    Screen shot is what we have, so 62 columns, 1 row of dates and 1 row of data and it goes from the 1st to 31st, 

     

    Thanks for the help!