Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Putting Remarks on same Vendor

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

 

 

 

Need Help

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    Hi Anonymous ,

     

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

     

    Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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