topic Re: Add Column with remarks verified after checking last row in DAX Commands and Tips

Add Column with remarks verified after checking last row

Afpujiha — Fri, 24 Jan 2020 10:07:22 GMT

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

Re: Add Column with remarks verified after checking last row

Anonymous — Fri, 24 Jan 2020 11:14:18 GMT

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.

Re: Add Column with remarks verified after checking last row

Anonymous — Fri, 24 Jan 2020 11:18:39 GMT

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.