I'm trying to create different restricted measures in the modeler with the RESTRICT function all based on the same variable ('ZVI_CALYEAR') in order to choose the year to restrict.
I've one measure for Year N which is working well : RESTRICT([Amount],[d/Year]=['ZVI_CALYEAR'])
But I want to restrict also for N+1, N+2 regarding the variable chosen. I've tried to use dynamic time navigation functions (https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/2784376d431e4a7da9564880dadb084d.html#loio2784376d431e4a7da9564880dadb084d__section_how) but it's not working with variable : RESTRICT([Amount],[d/Year]=Next(['ZVI_CALYEAR'],1)) or RESTRICT([Amount],[d/Year]=Next("Year",1).['ZVI_CALYEAR'])
Can you help me,