Display next month / year

[jerryr125]

Hi - I would like to have a KPI display the next month (Month Year) based upon the filters.

'Next Months Forecast ('&SalesDate(Max(Date.autoCalendar.Date])+1, 'MMMM YYYY')&')'

The field is SalesDate.

The above does not seem to work - thoughts ? Jerry

[treysmithdev · Accepted solution]

Try this:

'Next Months Forecast ('&Date(AddMonths(Max(Date.autoCalendar.Date]),1), 'MMMM YYYY')&')'