Forum Discussion

Hussein_charif's avatar
Hussein_charif
Icon for Helper V rankHelper V
1 year ago
Solved

Versus previous

Hi, i wanted to check if there is a similar function to the previous() visual calculation function but with measures? Also, i have this visual calc: Diff IF( ISINSCOPE([itemno]) && NOT ISINSCOPE...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    1 year ago

    Yes, by using PREVIOUS() and indicating which direction you want to look.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Yes, by using PREVIOUS() and indicating which direction you want to look.

Hussein_charif's avatar
Hussein_charif
Icon for Helper V rankHelper V
1 year ago

used PREVIOUS([Total AVG Cost],1,-1) and it worked, thank you