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
[TABLE="width: 383"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/01/17[/TD]
[TD]Mon[/TD]
[TD="align: right"]$2,365[/TD]
[TD="align: right"]$2,238[/TD]
[TD="align: right"]$2,394[/TD]
[/TR]
[TR]
[TD]05/02/17[/TD]
[TD]Tue[/TD]
[TD="align: right"]$3,468[/TD]
[TD="align: right"]$3,941[/TD]
[TD="align: right"]$3,493[/TD]
[/TR]
[TR]
[TD]05/03/17[/TD]
[TD]Wed[/TD]
[TD="align: right"]$9,261[/TD]
[TD="align: right"]$2,483[/TD]
[TD="align: right"]$7,142[/TD]
[/TR]
[TR]
[TD]05/04/17[/TD]
[TD]Thu[/TD]
[TD="align: right"]$3,355[/TD]
[TD="align: right"]$4,221[/TD]
[TD="align: right"]$4,504[/TD]
[/TR]
[TR]
[TD]05/05/17[/TD]
[TD]Fri[/TD]
[TD="align: right"]$7,137[/TD]
[TD="align: right"]$3,581[/TD]
[TD="align: right"]$5,888[/TD]
[/TR]
[TR]
[TD]05/06/17[/TD]
[TD]Sat[/TD]
[TD="align: right"]$7,139[/TD]
[TD="align: right"]$4,504[/TD]
[TD="align: right"]$6,497[/TD]
[/TR]
[TR]
[TD]05/07/17[/TD]
[TD]Sun[/TD]
[TD="align: right"]$3,549[/TD]
[TD="align: right"]$3,328[/TD]
[TD="align: right"]$2,069[/TD]
[/TR]
[TR]
[TD]05/08/17[/TD]
[TD]Mon[/TD]
[TD="align: right"]$5,283[/TD]
[TD="align: right"]$3,062[/TD]
[TD="align: right"]$3,096[/TD]
[/TR]
[TR]
[TD]05/09/17[/TD]
[TD]Tue[/TD]
[TD="align: right"]$6,559[/TD]
[TD="align: right"]$2,789[/TD]
[TD="align: right"]$2,773[/TD]
[/TR]
[TR]
[TD]05/10/17[/TD]
[TD]Wed[/TD]
[TD="align: right"]$5,893[/TD]
[TD="align: right"]$2,250[/TD]
[TD="align: right"]$7,771[/TD]
[/TR]
[TR]
[TD]05/11/17[/TD]
[TD]Thu[/TD]
[TD="align: right"]$5,439[/TD]
[TD="align: right"]$5,147[/TD]
[TD="align: right"]$2,148[/TD]
[/TR]
[TR]
[TD]05/12/17[/TD]
[TD]Fri[/TD]
[TD="align: right"]$8,593[/TD]
[TD="align: right"]$3,278[/TD]
[TD="align: right"]$5,088[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 383"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/01/17[/TD]
[TD]Mon[/TD]
[TD="align: right"]$2,365[/TD]
[TD="align: right"]$2,238[/TD]
[TD="align: right"]$2,394[/TD]
[/TR]
[TR]
[TD]05/02/17[/TD]
[TD]Tue[/TD]
[TD="align: right"]$3,468[/TD]
[TD="align: right"]$3,941[/TD]
[TD="align: right"]$3,493[/TD]
[/TR]
[TR]
[TD]05/03/17[/TD]
[TD]Wed[/TD]
[TD="align: right"]$9,261[/TD]
[TD="align: right"]$2,483[/TD]
[TD="align: right"]$7,142[/TD]
[/TR]
[TR]
[TD]05/04/17[/TD]
[TD]Thu[/TD]
[TD="align: right"]$3,355[/TD]
[TD="align: right"]$4,221[/TD]
[TD="align: right"]$4,504[/TD]
[/TR]
[TR]
[TD]05/05/17[/TD]
[TD]Fri[/TD]
[TD="align: right"]$7,137[/TD]
[TD="align: right"]$3,581[/TD]
[TD="align: right"]$5,888[/TD]
[/TR]
[TR]
[TD]05/06/17[/TD]
[TD]Sat[/TD]
[TD="align: right"]$7,139[/TD]
[TD="align: right"]$4,504[/TD]
[TD="align: right"]$6,497[/TD]
[/TR]
[TR]
[TD]05/07/17[/TD]
[TD]Sun[/TD]
[TD="align: right"]$3,549[/TD]
[TD="align: right"]$3,328[/TD]
[TD="align: right"]$2,069[/TD]
[/TR]
[TR]
[TD]05/08/17[/TD]
[TD]Mon[/TD]
[TD="align: right"]$5,283[/TD]
[TD="align: right"]$3,062[/TD]
[TD="align: right"]$3,096[/TD]
[/TR]
[TR]
[TD]05/09/17[/TD]
[TD]Tue[/TD]
[TD="align: right"]$6,559[/TD]
[TD="align: right"]$2,789[/TD]
[TD="align: right"]$2,773[/TD]
[/TR]
[TR]
[TD]05/10/17[/TD]
[TD]Wed[/TD]
[TD="align: right"]$5,893[/TD]
[TD="align: right"]$2,250[/TD]
[TD="align: right"]$7,771[/TD]
[/TR]
[TR]
[TD]05/11/17[/TD]
[TD]Thu[/TD]
[TD="align: right"]$5,439[/TD]
[TD="align: right"]$5,147[/TD]
[TD="align: right"]$2,148[/TD]
[/TR]
[TR]
[TD]05/12/17[/TD]
[TD]Fri[/TD]
[TD="align: right"]$8,593[/TD]
[TD="align: right"]$3,278[/TD]
[TD="align: right"]$5,088[/TD]
[/TR]
</tbody>[/TABLE]
