Forum Discussion

Anmol's avatar
Anmol
Frequent Visitor
6 years ago
Solved

Using Earlier() command for lag

I am having a hard time to get a expected output on a calculated column, i know how to get it through sql though using window function(lag). Here is the sql command:   select   (select lag(input_p...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anmol ,

     

    Let me know  if this works for you.

     

     

     

    Create Calculated Columns

     

    Previous_Value = CALCULATE(
    MAX('Table'[Input_Priority]),
    FILTER('Table','Table'[Task_Id] = EARLIER('Table'[Task_Id]) && 'Table'[Request_DateTime] < EARLIER('Table'[Request_DateTime] )))
     
     
    RANK_ = RANKX(
    FILTER('Table',
    'Table'[Task_Id] = EARLIER('Table'[Task_Id])
    ),
    'Table'[Request_DateTime] 
    ,,ASC,Dense)
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     
AlB's avatar
AlB
Community Champion
6 years ago

Hi Anmol 

Can you show a sample of the table you are using and explain with an example based on that data/table what you would need?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

  • Anmol's avatar
    Anmol
    Frequent Visitor
    6 years ago

    That's how the data looks like, im just looking for a calculated column that gives previous 'input_priority' only after sorting the data on 'task_id' and 'request_datetime'.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI Anmol ,

       

      Let me know  if this works for you.

       

       

       

      Create Calculated Columns

       

      Previous_Value = CALCULATE(
      MAX('Table'[Input_Priority]),
      FILTER('Table','Table'[Task_Id] = EARLIER('Table'[Task_Id]) && 'Table'[Request_DateTime] < EARLIER('Table'[Request_DateTime] )))
       
       
      RANK_ = RANKX(
      FILTER('Table',
      'Table'[Task_Id] = EARLIER('Table'[Task_Id])
      ),
      'Table'[Request_DateTime] 
      ,,ASC,Dense)
       

      Regards,
      Harsh Nathani

      Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)