Set value for all records with same ID based on column value

[Anonymous]

Dear Community,

I am trying to add new column.

If product include "A" then all id can get same value

Is it possible?

Regards,

Betty

[amitchandak · Accepted solution]

@Anonymous , A new column

var _1 = countx(filter(Table, [order] = earlier([order]) && [product] = "A") , [Order])
return
if(isblank(_1), Blank() , "V")

[Anonymous]

I appreciate your help very much. 😁