Joining to SharePoint Library on split (delimited) column value

I need to join an existing data model to a SharePoint Document Library, and we'd normally do that using a single-line-of-text column that would have a unique identifier in it that facilitates the join.  Now, we have situations where a single document should be joined to multiple different unique identifiers in the Power BI data model.  I'd rather not use managed metadata with multiple selections if possible, are there other ways to do this?  Can I separate the unique identifiers with a delimiter and split that field when joining?  

Thanks!