Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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