DAX Measure to compare tendency with previous month

[Cicopal]

Is this possible compare a measure tendency with previous month result? Green is my result month by month, in dark I have my tendency to current month.when I filter by last month my graphic return to me 0 tendency

 anyone can help?

[v-cherch-msft · Accepted solution]

Hi @Cicopal

You may create measures as below to get the last month value. Show a simplified sample here.

Current = CALCULATE(SUM(Table1[sales]))

LastMonth = CALCULATE(SUM(Table1[sales]),FILTER(ALL(Table1),Table1[Month]=MAX(Table1[Month])-1))

Regards,

Cherie

[adriano321souza]

Good afternoon, can you share the file?