Forum Discussion
Do need a separate date table
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?
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
4 Replies
lukiz84Memorable Member
You can, but then you are missing time intelligence features.
- 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.
- v-easonf-msft
Community Support
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