Total sales for previous calendar month

[jpriemer]

Hello, I am trying to calculate the total sales of the previous month. For example, today is Feb 8 and I want to see the total sales from all of January. Below is the formula I am using but I am getting the previous month from today, so Jan 8 - Feb 8. What am I doing wrong? 

Value MTD =

TOTALMTD(SUM(Opportunity[Actual Value]),PREVIOUSMONTH('Actual Close Date Parts'[Date].[Date]))

[jpriemer · Accepted solution]

I was able to get the calculation to work by using the following DAX:

last_month_sales = var current_month= MONTH(TODAY()) return CALCULATE(SUM(Opportunity[Actual Value]),FILTER('Date Table',MONTH('Date Table'[Date])=current_month -1))

[amitchandak]

@jpriemer , Please use date table in this case

Value MTD =
calculate(SUM(Opportunity[Actual Value]),PREVIOUSMONTH('DAte'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[jpriemer]

Thank you so much for the quick response. Unfortunately, I am still getting values Jan 8 - Feb 8?

Here is my edited formula: 

Value MTD =

CALCULATE(SUM(Opportunity[Actual Value]),PREVIOUSMONTH('Actual Close Date Parts'[Date].[Date]))