create flag when other same id in table has value "x"

[newtopbitoo]

I have a table containing rows with same Id's.
I want to flag every Id when one of the rows with the same Id when column  y has value x.

I found several options to do it in Dax but would like to have this in power query. Did not find a solution so far.

[noobtopowerbi]

I am afraid that my question was not clear.
See screenshot. I want to flag all same id's when one of those id's meets a condition

[v-stephen-msft]

Hi @newtopbitoo ,

Here's the solution in Power Query:

Sample data:

Steps:

1.Group by

2.Add a conditional column.

3.Expand the column contains tables and remove the unneeded columns.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[PijushRoy]

@newtopbitoo 
Can you please share screenshot of your data and expected result