Calculated Column based on Most Significant Value

Hi,   I am trying to create a new column within Power BI that sets the value based on reading the most significant string. Basically, I have list of servers that are being used by different applica...