Possible to create a Cumulative Sales Measure in DAX

[thomdeluca]

New PowerPivot user question.

Below is a screen capture of a Pivot of some sample data.

What I'd like to do is to create a new Measure (3 really that accomplish the same result) which will calculate a cumulative sales value. Said differenty, the 4/19/14 column would have the existing measure, "Total Sales" which is sales for that one week, and a NEW measure, "Cumulative Sales" which is the sum of 4/19/14 and 4/12/14. This would continue "building" into perpetuity.

The end goal is to create a bar-line chart showing bars for each week, and a corresponding line, plotting the Cumulative Sales to show a "sales build".

I do appreciate any help!


[TABLE="width: 662"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]ItemName[/TD]
[TD]Values[/TD]
[TD] 4/12/14[/TD]
[TD] 4/19/14[/TD]
[TD] 4/26/14[/TD]
[TD] 5/3/20[/TD]
[TD] 5/10/14[/TD]
[/TR]
[TR]
[TD]Orange - 2Ct[/TD]
[TD]#StoresScanning[/TD]
[TD="align: right"]310[/TD]
[TD="align: right"]404[/TD]
[TD="align: right"]514[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]1,606[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Sales[/TD]
[TD="align: right"]$1,195[/TD]
[TD="align: right"]$1,550[/TD]
[TD="align: right"]$2,201[/TD]
[TD="align: right"]$2,171[/TD]
[TD="align: right"]$6,606[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Units[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]438[/TD]
[TD="align: right"]692[/TD]
[TD="align: right"]619[/TD]
[TD="align: right"]2,161[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Forecast Units[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]Orange - 10Ct[/TD]
[TD]#StoresScanning[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]238[/TD]
[TD="align: right"]286[/TD]
[TD="align: right"]349[/TD]
[TD="align: right"]387[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Sales[/TD]
[TD="align: right"]$2,232[/TD]
[TD="align: right"]$3,346[/TD]
[TD="align: right"]$4,249[/TD]
[TD="align: right"]$4,812[/TD]
[TD="align: right"]$5,370[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Units[/TD]
[TD="align: right"]183[/TD]
[TD="align: right"]276[/TD]
[TD="align: right"]391[/TD]
[TD="align: right"]394[/TD]
[TD="align: right"]442[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Forecast Units[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[ruve1k]

Cumulative Total – Dax Patterns