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 t...
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.