Formula Help

[ANDREPIJDI]

I'm trying to display total sales from the previous month this is the formula i used:

PriorMonth:=CALCULATE(SUM(DATA[NonTaxableSalesAmt]),DATESMTD(DATA[InvoiceDate]))

But it just shows the sales from the current month

I am using excel 2013 powerpivot.

What am i doing wrong???

 

[scottsen]

DATESMTD is "month to date". You are looking for PREVIOUSMONTH.