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)

     
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)