cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Month over month calculations with Dates table

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??

1 ACCEPTED SOLUTION
Super User

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?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2

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.

Super User

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?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...