Create a MoM % sales change KPI

zedmo — Wed, 28 Feb 2024 21:06:30 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

Zapparoli — Thu, 29 Feb 2024 00:10:38 GMT

So, your solution is actually correct and looks simple for me.

If your application needs to use more complex operations using month over months, rolling averages of some sort, you can use a AsOfCalendar.

In your scenario I would stay with your solution.

Something like this, would do the trick.

Addmonths(Max(Date),0) / Addmonths(Max(Date),-1)

Hope this helps.

-Zapparoli