Hi everyone 👋

I’m currently trying to build a formula that returns Actuals across different versions.

What I’d really like is to have something like a dynamic SELECT[MONTH - X], so it always pulls the correct month automatically.

I already managed to create a working formula above, but I’m not fully satisfied — it feels like there should be a simpler and more dynamic way to achieve this.

I  tried as below creating a metric to use as a pointer with SELECT: Month = Technical Metric with the function Edate OR  SELECT: Month - Technical Metric but it didn’t work as expected.

When I attempt this, I get the following error: 

The strange thing is that both metrics do share the same dimensions (Month + Version), so I’m not sure why Pigment doesn’t allow the SELECT here.

What’s the best way, in your opinion, to dynamically retrieve data for different months using SELECT or other approaches ?

Thanks a lot for your help !