Add Column with remarks verified after checking last row

[Afpujiha]

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

[Anonymous]

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]

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.