Do need a separate date table

[Anonymous]

I have a simple Date, and Count columns in my source data. I won't need to relate the data to any other tables or files.

Can I simply add Year, Month, MonthName, Week, WeekNum etc etc in the same table rather then building a separate date table and creating a relationship?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Yes, you can try using the format function to add Year, Month, MonthName, Week, WeekNum etc etc in the same table rather then building a separate date table and creating a relationship

Year1 = FORMAT(Sheet1[Date],"yyyy") 

Month = FORMAT(Sheet1[Date],"mm") 

Monthname = FORMAT(Sheet1[Date],"mmmm") 

Week = FORMAT(Sheet1[Date],"w") 

Weeknum = FORMAT(Sheet1[Date],"ww") 

https://learn.microsoft.com/en-us/dax/format-function-dax 

Best Regards,
Community Support Team _ Eason

[lukiz84]

You can, but then you are missing time intelligence features.

[Anonymous]

Oh what time intelligence features would i be missing?  If i add in all the date based columns, what else would i be missing?

[lukiz84]

All of them 😄

Time Intelligence – DAX Guide

But if you don't need them, then it's ok to just add the fields you like to use.