Date hierarchy with weeks, weeks part of two quarters

[bcastro19]

Hi All, 

I need to break down a graph by quarter, month, then week. I included the week by having a "Week End Date Column" in my date table. 

Week End Date = 'Date Table'[Date].[Date] + 7-WEEKDAY('Date Table'[Date].[Date],1)

I used the above and I was able to show weekly sales. However, when I filter, for example, to view only 2022 Q2 sales, I am seeing 2022 Q3 sales appear since part of the week is part of Q2 (6/27-6/30) and part of the week is Q3 (7/1-7/2). How can I get my graph to include the few days after the quarter date to appear in Q2 and start Q3 on 7/3? Will I have to manually set the quarters in my date graph to create the correct hierarchy? Thanks for any help in advance! 

[lbendlin]

Use an external Calendar table and manage the "Quarter Week"  value there.