You need to be more specific. Does it has to be green? Are you looking for a PowerQuery solution or a DAX solution? Does it needs to be a filtered table or a new calculated table?
What are you actually trying to achieve? We are missing a whole lot information. If you can't provide more information, then going on what you described you can filter the Color column in the PowerQuery Editor and select only 1 column, click Save & Apply and then your table only contains that color.
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Did I answer your question? Mark my post as a solution!
Thank you for your response. Originally, I wanted a new table where only the IDs that contained the color would remain based on the color you selected (green in the example). But I would need to mark all IDs that contained the color as follows:
ID , colour , new column
1, black , green
1, red, green
1, green, green
2, black, no green
2, red, no green
3, black, no green
4, red, no green
5, white, green
5, green, green
i know simple mark green with:
=IF([colour]="green";"green";"no green") , this work for 1, green and 5, green. But i need mark with "green" another rows :1, black and 1, red, and 5 white.