Hi all - I’m looking to calculate the maximum value of the last 3 months but seem to be getting incorrect values with my current formula. Adding screenshots below. Tried “MAX(Value, Valueaselect: Month - 1], Valueaselect: Month - 2])” but it seems to be causing a mismatch in dimensionality somehow.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/e5bd8738-2ad3-4829-b71c-a12f0b5afa5e.png)