Forum Discussion
Anonymous
6 years agoNot applicable
Add fiscal week range in date table
Hi I have a date table wrote as below, I would like to have another column that gives me the explanation of those week numbers.
Date Table =
ADDCOLUMNS(
CALENDAR(DATE(YEAR(TODAY()) - 5, 1, 1),TODAY()),
"Day", DAY([Date]),
"Day Name", FORMAT([Date], "ddd"),
"Week Number",WEEKNUM([Date],2),
"Month Name", FORMAT([Date], "mmm"),
"Month Number", MONTH([Date]),
"Quarter", "Q" & ROUNDUP(MONTH([Date])/3,0),
"Quarter Year", FORMAT([Date], "yy") & "Q" & ROUNDUP(MONTH([Date])/3,0),
"Year", YEAR([Date]))For example, the new column would gives me the explanation of date range for that week. Like (1/7/2019- 1/12/2019) appeared in new column for all 7 rows associates with the week number is 2.
Any help would be greatly appreciated!
Thanks a lot!!
1 Reply
- aTChris
Resolver I
You might find this post useful although it's within the query editor.
Good luck!