Prior Month's Sales -

Question

Hello,&nbsp;&nbsp;I am using a couple of different measures to calculate the previous month's total sales&nbsp; (not the last 30 days, but the actual previous calendar month). &nbsp; So in this case, today is Sept 30 I want all of August. &nbsp;&nbsp;Both of these work. &nbsp; But they require that I have a filter visual set to the current month. &nbsp; Which means I have to remember to change it each month. &nbsp; Is there a more dynamic way to do this that automatically adjusts? &nbsp;&nbsp;&nbsp;Last Month Shipped = CALCULATE([Total Shipped Value], PREVIOUSMONTH(Dates[Date]))&nbsp;&nbsp;PriorMTD Orders = CALCULATE([Total Orders]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,DATEADD(DATESMTD(Dates[Date])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,MONTH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )

amitchandak · Answer

I think these are the best option. To make your date selection dynamic. Put that to filter pane and use Advance or relative date&nbsp;

Forum Discussion

Prior Month's Sales -

1 Reply

Related content

Remaining Balance Depends on Prior Month

LAST MONTHS SALES

Return 12 months Prior Sales Dependant on Period Selected

Prior Year 12 rolling month cumulative sales,

need to display monthly sales and 6 month average sales for products