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)