Previous function in Calculated measure

[arkaitz_orozko]

Hi,

Actually, we are trying to create a new calculated measure with Previous function in RESULTLOOKUP sentence. As you can see in screenshot, te system gives an error. Does anyone know the possible cause? This new funcionality is available since last update.

Regards,

[N1kh1l]

arkaitz_orozko

Try replacing RESILTLOOKUP with LOOKUP

LOOKUP([QUANTITY] ,[d/Date]= Previous("Month", 1))

Dynamic Time navigation is only supported in LOOKUP and RESTRICT. See details below.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/2784376d431e4a7da9564...

Please upvote/accept if this helps.

-Nikhil