Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating previous row with earlier function

Hello,   I have the date, user, value columns. In a date, I can have many users and the value for each user should grow. I need to know when a value is smaller for a later date. I cannot use index...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Anonymous ,

    No problem. Here you go


    You just need to change the variables _curr and _rank and it will work fine.

    var _curr = MinVal[Value]

    var _rank = MinVal[Rank]
     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

     

     



Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your answer Rohit. This solution works for a measure but I need to apply it in a column, for a column all values are 0.

  • rohit_singh's avatar
    rohit_singh
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous ,

    No problem. Here you go


    You just need to change the variables _curr and _rank and it will work fine.

    var _curr = MinVal[Value]

    var _rank = MinVal[Rank]
     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂