Month over month calculations with Dates table

[JulieGueho]

I don't understand how the time intelligence functions are working.

I created two measures

Sales July 2015 = CALCULATE(SUM(Revenue), DATESBETWEEN(Dates[Date], DATE(2015,7,1), DATE(2015,7,31)))

Sales Previous Month = CALCULATE([Sales July 2015], PREVIOUSMONTH(Dates[Date]))

Problem: Sales July 2015 gives the same result than Sales Previous Month

If I do: Sales Previous Month = CALCULATE([Sales July 2015], PREVIOUSMONTH(DATESBETWEEN(Dates[Date], DATE(2015,7,1), DATE(2015,7,31))))

it works fine.

I don't get how the time intelligence functions are working. What am I missing??

[DominikPetri]

Why don't you use DATEADD to shift the dates 1 months back?

Try this:

Sales Previous Month = CALCULATE([Sales July 2015], DATEADD( Dates[Date], -1, MONTH ) )

Best regards

Dominik Petri.

[Greg_Deckler · Accepted solution]

PREVIOUSMONTH returns all dates from the previous month based on the first value in the dates column, so I am guessing that your first date is August so it is dumb luck that it is the same as your July?