Hi I'm looking to sum week to date sales. And MTD sales year over year.
I have to data in power pivot and have created a pivot table. So I'm fine with creating an excel formula to get the results. Or if needed using a DAX function.
My data starts at B4 with the date 05/01/17
B C D E F
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
I have to data in power pivot and have created a pivot table. So I'm fine with creating an excel formula to get the results. Or if needed using a DAX function.
My data starts at B4 with the date 05/01/17
B C D E F
DATE | DAY | 2015 | 2016 | 2017 |
1000 | ||||
05/01/17 | Mon | $2,365 | $2,238 | $2,394 |
05/02/17 | Tue | $3,468 | $3,941 | $3,493 |
05/03/17 | Wed | $9,261 | $2,483 | $7,142 |
05/04/17 | Thu | $3,355 | $4,221 | $4,504 |
05/05/17 | Fri | $7,137 | $3,581 | $5,888 |
05/06/17 | Sat | $7,139 | $4,504 | $6,497 |
05/07/17 | Sun | $3,549 | $3,328 | $2,069 |
05/08/17 | Mon | $5,283 | $3,062 | $3,096 |
05/09/17 | Tue | $6,559 | $2,789 | $2,773 |
05/10/17 | Wed | $5,893 | $2,250 | $7,771 |
05/11/17 | Thu | $5,439 | $5,147 | $2,148 |
05/12/17 | Fri | $8,593 | $3,278 | $5,088 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>