Calculate Difference between values (current/prior and % diff)

tiverson

I have a data output where it adds a column when a new period is opened.

I want to calculate the difference between the prior  month and the current month, then calculate the % difference.

Is it easier to have a data input for the current period, then build logic to return that value....and the column 1 month prior?

Or how could I designate data that is from the current period vs prior period and do calculations from that?

Data

Desired Output 

Thanks for any help!

Current-Prior month data.xlsx

Raj

@tiverson are you looking for the formula to get the output for this file or do you want the logic to make this a dynamic thing?