Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try:
=Sum({<Month={"$(=Month(AddMonths(Max(Date),-1)))"}>}Quantity)
Perfect!
Thank you.