Salesforce: Get Campaign Name based on ID in Account object

[PBrainNWH]

I have a bunch of Salesforce objects I'm connected to and on my Account object I have a field called Last Soft Credit Campaign. It's an Id referencing the Campaign object. When I try and connect this Id to the Campaign Id in the Campaign object I get this error:

I feel good about the data model, so don't want to break the relationship between the Campaign and Opportunity objects. What is a good way to be able to get the Campaign Name from the Campaign object for the Last Soft Credit Campaign Id in my Account object? Calculated Table? Add Column? Stuck on what to do.

[TomasAndersson · Accepted solution]

Hi!
Could LOOKUPVALUE() maybe be a part of your solution? LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

[PBrainNWH]

Perfect. Thank you!