MOM Calculation

[shivanand612]

Hi All,

I would like to calculate MOM for below data.

Date	Value
1/1/2021	12
1/2/2021	21
1/3/2021	33
1/4/2021	41

Result i am looking is 

Date	Value	MOM
1/1/2021	12	0
1/2/2021	21	0.75
1/3/2021	33	0.571429
1/4/2021	41	0.242424

Thanks in advance.

Regards,

Shiva

[mmish]

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

[atcodedog05]

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:

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 · Accepted solution]

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

[atcodedog05]

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]

Thank you 🙂