Calculate Month over Month when Months are in Separate Columns

Hi Everyone,

I'm looking to calculate the month over month change for each month in my dataset. However, I'm running into some difficulties because the month values are in separate columns (see input structure screenshot below) and the workflow needs to be dynamic to accommodate any future month columns that will be eventually added to the data. Ideally I would like the MoM change column to be located next to each respective month e.g. Jan-21 MoM will be located next to Jan-21 in the output (see desired output structure screenshot below).

The month over month column can just be null for the first month in the dataset since there will be no prior month's data to be used in the calculation.

Attached is the dataset containing an Input tab to be used in the workflow and a desired output tab for reference. Any help is appreciated.

Input Structure:

Desired Output Structure:

Thank you,

Paul

MonthOverMonth_AlteryxDiscussion.xlsx

Workflow

Datasets

Input

Output

Date Time

Accepted answers

atcodedog05

Hi @paulwini

2 values was bit more complicated. I have duplicated the data for sales and count.

Here is how you can do it.

Workflow:

Hope this helps : )

monthly variance sales and count.yxmd

atcodedog05

Hi @paulwini

Here is how you can do it.

Workflow:

Hope this helps : )

monthly variance sales and count (1).yxmd

All comments

atcodedog05

Hi @paulwini

Here is how you can do it.

Workflow:

Hope this helps : )

monthly variance.yxmd

paulwini

@atcodedog05 Wow thank you so much! Incredibly helpful. If I had additional data broken out by Sales & Count (see edited post & data), what would be the easiest way to accomplish the desired output using your methodology?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703