Create a MoM % sales change KPI

phelo — Mon, 08 Jan 2024 10:15:38 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 — Fri, 12 Jan 2024 20:50:22 GMT

try following

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

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