In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

MOM Calculation

shivanand612
7 - Meteor

Hi All,

 

I would like to calculate MOM for below data.

DateValue
1/1/202112
1/2/202121
1/3/202133
1/4/202141

 

Result i am looking is 

DateValueMOM
1/1/2021120
1/2/2021210.75
1/3/2021330.571429
1/4/2021410.242424

 

Thanks in advance.

 

Regards,

Shiva

5 REPLIES 5
mmish
6 - Meteoroid

Apologies, I confused month over month with multiple of the median.

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @shivanand612 

 

If your caculation for MoM is [previous month] / [current month] you can do this with Multi-row formula tool. Considering your data is sorted ascending on date MoM calculation will be [previous row value] / [current row value]

 

Workflow:

atcodedog05_0-1622743522917.png

 

Here is an interactive lesson on Multi-row formula tool : https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872 

 

Hope this helps 🙂

Luke_C
17 - Castor
17 - Castor

Same as @atcodedog05  but tweaking the formula a bit to get the desired answer

 

Luke_C_0-1622743922947.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Luke_C 

 

I had guessed that could have been the formula 😅 while the current one didnt give the expected, but left it. Good job on capturing it and getting expected output. 🙂👍

shivanand612
7 - Meteor

Thank you 🙂

Labels
Top Solution Authors