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...
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.