Weekly Calculation With YoY aspect

[Typical_Analyst]

Hello,

I'm trying to take a table with the structure of the following:

I'm trying to create an output to resemble the following table and graph:

I keep running into the problem with due to not every product having a date within a week that my max/min for a week beginning and end are not the same for all products. Do I need to create a calandar table to link and calculate my measures off of or is there a way to do this without a calandar table?

Thanks

[_AAndrade]

Create a date calendar and make a relationship with date calendar and date of your fact table.

Using a simple measure of sum of dolar (or a sumx if the dollar column is unit price) and you will be able do build your chart like you want