Prior month by selected month

[Anonymous]

Hi!

How i can get prior month from by selected month ?

For example, if i choose october, i need to get september

Thank you!

There is attached model

[Anonymous]

where you want to get the previous month?

can you explain mor eindetail within your application?

you can use addmonths for instance

addmonths(date,-1) will get you the previous month

[tresesco · Accepted solution]

Try:

=Sum({<Month={"$(=Month(AddMonths(Max(Date),-1)))"}>}Quantity)

[Anonymous]

Perfect!

Thank you.