Forum Discussion

faustusxanthis's avatar
faustusxanthis
Frequent Visitor
3 years ago
Solved

Calculate value from previous month

Hello! 

 

I am currently stuck with this problem and I can't seem to find the solution anywhere. 

 

I currently have a table with 3 columns that look like this:

 

 

I would like to have a calculated column such that it gives the difference of volume from the previous month so it looks like this: 

 

Thanks in advance!

  • I got it. I used LOOKUPVALUE. 

    =[Volume]- LOOKUPVALUE([Volume], [Reason], [Reason], [Month], PREVIOUSMONTH([Month]))

1 Reply

  • I got it. I used LOOKUPVALUE. 

    =[Volume]- LOOKUPVALUE([Volume], [Reason], [Reason], [Month], PREVIOUSMONTH([Month]))