Display next month / year

jerryr125 — Wed, 23 Oct 2019 01:10:18 GMT

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

Re: Display next month / year

treysmithdev — Wed, 23 Oct 2019 01:39:57 GMT

Try this:

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