Forum Discussion

Afpujiha's avatar
Afpujiha
New Member
6 years ago

Add Column with remarks verified after checking last row

Hi,

 

I would like to add column with remarks verified with condition as following :

If status = Reject , then next row status is OK with same production date time then give remarks Verified.

The data as following :

Any one have experience and kindly help for the formula.

 

Many Thanks,

Azis

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Afpujiha 

     

    Try this,

     

    Remark = var next_col = CALCULATE(FIRSTNONBLANK(Sheet[Status],1),FILTER(Sheet,Sheet[Date]=EARLIER(Sheet[Date]) && Sheet[Index]=EARLIER(Sheet[Index])+1))
    return
    IF(Sheet[Status]="reject" && next_col="Ok","Varified")
     
     
    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      forgot to mention create one index column in your model.

       

      If hist_id is sequential then you can use it instead of hist_id.

       

      and convert your date to specific format and remove that time.

       

       

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.