Create a MoM % sales change KPI

jazmin8 — Mon, 26 Jan 2026 18:19:17 GMT

Hi! I am trying to have a % change month over month kpi indicator for sales, based on the selection of a date.

I am thinking on using set analysis for this, to grab the max of current month minus max of current month -1.

However I would lik to know if any of you have a simple way to calculate MoM %

Any help would be appreciated!

Re: Create a MoM % sales change KPI

anat — Sat, 16 Sep 2023 06:09:27 GMT

try following

Previous Month:

Sum({$<[month_year]=,[month_year]={"$(=Date(AddMonths(Max(month_year), -1), 'MMM-YYYY'))"}>} sales)

For current month:

Sum({$<[month_year]={"$(=Date(Max(month_year), 'MMM-YYYY'))"}>} sales)