New to powerbi, stuck in a situation. Have this lookup table with 1:many relationship. The source table may have Referral - Employee/ hiring manager/ other in source sub-type and source details may have any name.
Source alignment is Source sub-type&Source details and have the same calculated column in other files.
The challenge is to assign the source type as Referral - Employee if Source alignment is "Referral - EmployeeJohn Smith" or any other name.