PreviousMonth difference

[Olia]

Hi everyone,

I'm using the following formula (taken from this forum btw) as a measure

Change GC = sum('Sheet'[Group Amount]) - CALCULATE(sum('Sheet'[Group Amount]),PREVIOUSMONTH('Sheet'[Date]))

But when checking if it really shows the Change between months, I get this...

This is not correct. Change should be $8.96

 what am I doing wrong?

[Olia · Accepted solution]

I got it!!!!

For anyone with same error: the problem is that Previous month returns 0, unless you add an extra .[Date] at the end of the formula (don't ask me why, plz)

so for some reason, it looks like this:

CALCULATE(sum('Sheet'[Group Amount]),PREVIOUSMONTH('Sheet'[Date].[Date]))

[v-lili6-msft · Accepted solution]

Hi@ Olia 

When you use time intelligence function ,you  need a date table  and create relationship between them like below:

Then create measure:

Change GC = CALCULATE(SUM(Table2[Qty]))-CALCULATE(sum(Table2[Qty]),PREVIOUSMONTH('Date'[Date]))

Result:

Best Regards,

Lin

[Olia · Accepted solution]

I got it!!!!

For anyone with same error: the problem is that Previous month returns 0, unless you add an extra .[Date] at the end of the formula (don't ask me why, plz)

so for some reason, it looks like this:

CALCULATE(sum('Sheet'[Group Amount]),PREVIOUSMONTH('Sheet'[Date].[Date]))