Adjust Calculated Column Based on Value from Unrelated Table

Hi All, 

I have a calculated column which returns some text or blank based on the condition below. 

Calcuated Column =  IF (
        Opportunities[Stage of Opportunity]
            IN {
            "Open - SWA Still Active",
            "Open - SWA Expired - Post Grace Period",
            "Open - SWA Expired - In Grace Period"
        }
            || Opportunities[Stage of Opportunity] = "SWA Lost"
            && Opportunities[Reason] = "Available for Winback",
        Opportunities[RequestQuoteURL],
        ""
    )

I have another unrelated table which defines the role of the user in the following format:

I want to adjust this calculated column above so that it only returns text if the user id is that of a partner. 

Any suggestions?