Forum Discussion
create flag when other same id in table has value "x"
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.
3 Replies
- PijushRoy
Community Champion
Anonymous
Can you please share screenshot of your data and expected result Hi Anonymous ,
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.
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
