Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jazmin8
Contributor
Contributor

Create a MoM % sales change KPI

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!

Labels (1)
  • Other

1 Reply
anat
Master
Master

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)