Add fiscal week range in date table

[Anonymous]

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

[aTChris]

You might find this post useful although it's within the query editor. 

https://community.powerbi.com/t5/Desktop/Min-Max-date-display-based-on-Week-number/m-p/669845#M32228...

Good luck!