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
You can, but then you are missing time intelligence features.
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.
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
