Calculate totals, pr week without a date in table

[JarrettM]

You have a column in the Date Table called" Week Ending". This will give you a date field that is every Sunday. Let me know if this solves your issue. You will also need to un filter your Date Table. You have it only showing Sunday right now. The go in and mark your Date Table as "Date Table. I have attached a post that explains this:

Mark as Date Table?

Hey everyone! I’m a very new Power BI user who”s in over his head at the moment, but I’m loving it! This is probably a dumb question, but as I’ve watched many of Sam’s videos, I’m getting up to speed on the concept of using a date table. However, I’ve never seen any mention of that table actually being marked as a date table in a Power BI using “Mark as Date Table.” My question is… is that just a step that everyone does, but you take it for granted so it’s never mentioned? Or are there reasons …

** You will also need to adjust your RevenueBudget Table. It really needs a Date Field so that you can create a proper relationship between it and the Date Table.**

** I have also attached your file with the Date Table marked as Date Table**
Revenue-budget (3).pbix (151.9 KB)

Thanks
Jarrett