Putting Remarks on same Vendor

[Anonymous]

Hi, Team

Seeking for your assistance 
below is the Formula I have use but I need as well if the Vendor got two or more in a column then will get remarks "For checking" as well

[Anonymous]

Hi @Anonymous ,

Please try like:

if List.Contains({"EUR","Blank","DDK","SEK"},[Part blank type]) then "For Checking" 
else if Table.RowCount(Table.SelectRows(#"Changed Type",(x)=>x[Vendor]=[Vendor]))>1 then "For Checking"
else null

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[BA_Pete]

Hi @Anonymous ,

Can you provide the example data in your screenshot in a copyable format please?

Pete