MOM IN TABLEAU

0 votes
What is MOM and How to find MOM% in tableau?
Jun 17, 2019 in Tableau by Keerthana
5,562 views

1 answer to this question.

0 votes

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.

answered Jun 18, 2019 by anonymous
• 33,010 points
(SUM([Sales]) - LOOKUP(SUM([Sales]) -1))/ (LOOKUP(SUM([Sales]), -1))

Tried the above calculation, no result.

Related Questions In Tableau

0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,095 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
5,304 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 4, 2018 in Tableau by QueenBee
• 1,820 points
525 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sal ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,179 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,037 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
813 views
+2 votes
1 answer
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 28, 2019 in Tableau by Cherukuri
• 33,010 points
853 views
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,010 points
7,786 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP