Shift measure one month down

[BearNBeer]

Hello,

I am trying to shift down the "Sales + 1 month" measure :

It should be equal to : 

Month(DATE)	Sales	Sales + 1 month
Juin	504	419
Juil.	419	298
aout	298	297
sept	297

I know I am supposed to use some set analysis but I can't figure out how.

Thanks for the help guys.

[Vegar · Accepted solution]

Try this expression :

=below(Sum(Sales)) 

[BearNBeer]

Way simpler that what I was trying to do ! Thank you very much 🙂