translation table for two databases

Hi MoMrCrane 

You can try to create a translation table manually. Click on the Home tab and select Enter Data. In the pop-up window, enter the mapping of the old unit name to the new unit name. For example, like this:

Create a one-to-many relationship between the translation table and the Legacy_MRC_INVOICE_DETAILS table.

Then create a calculated column in the Legacy_MRC_INVOICE_DETAILS table using the following DAX:

TranslatedUnit = 
LOOKUPVALUE(
    UnitTranslation[NewUnit],
    UnitTranslation[OldUnit], 'Legacy_MRC_INVOICE_DETAILS'[Unit],
    'Legacy_MRC_INVOICE_DETAILS'[Unit] 
)

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.