MOM IN TABLEAU

Question

What is MOM and How to find MOM% in tableau?

Answer 1

Month-over-month (MoM) growth shows the change in the value of a specific metric as a percentage of the previous month's value. Month-over-month growth is often used to measure the growth rate of monthly attributes such as sales, profit, etc.

It can be calculated as 

(SUM([Measure]) - LOOKUP(SUM([Measure]), -1)) / (LOOKUP(SUM([Measure]), -1))  

where measure is sales/ profot, etc.

Hope it helps!

For an in-depth explanation check out Tableau Training Course details.

Comments

(SUM([Sales]) - LOOKUP(SUM([Sales]) -1))/ (LOOKUP(SUM([Sales]), -1))

Tried the above calculation, no result.