31 date columns

[mwen90]

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!

[mwen90]

@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!

[PhilipTreacy]

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