Week over Week

Anonymous Here are some tips that may help:

You can create a measure to aggregate your sales, such as

Sales = SUM(Table[Sales])

and then you can figure out the prior week using the Week_Seq:

Prior Week = 

VAR ThisWeek = max(Table[Week_Seq])

VAR LastWeek = ThisWeek - 1

RETURN

CALCULATE([Sales],Table[Week_Seq] = LastWeek)

And putting it together you to see Week Over Week Change:

Week Over Week Change = 

DIVIDE([Sales]-[Prior Week],[Prior Week])

or 

Week Over Week Change = 

VAR ThisWeek = max(Table[Week_Seq])

VAR LastWeek = ThisWeek - 1

VAR ThisWeekSales = CALCULATE([Sales],Table[Week_Seq] = ThisWeek)

VAR LastWeekSales = CALCULATE([Sales],Table[Week_Seq] = LastWeek)

RETURN

DIVIDE(ThisWeekSales - LastWeekSales,LastWeekSales)

I can provide more specific guidence if you provide some of the data in a table too, as I am not sure how you are handling year over year in this example either.