not exists

[Anonymous]

Hi 

i need to achive below  table in powerbi if any order id having status as complete i need to mark all rows for that order id as Y

can you please help 

order id	Status	complete flag
244968	Complete	Y
244968	open	Y
244968	cancel	Y
269287	open	N
344968	Complete	Y

[amitchandak]

@Anonymous , Try a new column like

new complete flag =
var _cnt = countx(filter(Table,[order id] =earlier([order id]) && [status] ="Complete"),[order id] )+0
return
if(_cnt>=1, "Y",[complete flag])