Big challenge question for powerpivot.

[shophoney]

Ok. I hope i can explain this well.

I need to calculate sales increase for my stall. Here's the example and I just can't figure this out.

I want to work with powerpivot for many reasons.

I need to take last year's sales and add 10% for the GOAL. But here's the problem I also bonus my managers when the TOTAL MONTH is up 10% or more.

So lets assume Feb 1-28 /17 was Wednesday to Tuesday full month. And I want them to increase there sales this year Feb 1 starts on a Thursday.

So in my example last year Feb 1-28 the store did $100,000 so they need to do $110,000 for the month to have a 10% increase.

But the same weekdays add up to $95,000 so I need the store to do 13% more each day to complete the month up 10%.

I've loaded the sales from last year into powerpivot but cant figure out the formula. I've tried using date add

But I need to show each days sales for the month but add 13% so they hit the total.

Thanks