Forum Discussion
Set value for all records with same ID based on column value
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
Anonymous , A new column
var _1 = countx(filter(Table, [order] = earlier([order]) && [product] = "A") , [Order])
return
if(isblank(_1), Blank() , "V")
2 Replies
Anonymous , A new column
var _1 = countx(filter(Table, [order] = earlier([order]) && [product] = "A") , [Order])
return
if(isblank(_1), Blank() , "V")