Building a new table from two BI tables

Hi micklowe ,

According to your description, I made a sample and here is my solution.

I wonder whether I understand your requirement correctly, please follow steps below.

Sample data:

Create a new table as what you wrote.

ClientCodes =
SELECTCOLUMNS (
    FILTER ( 'TABLE_A', 'TABLE_A'[AG_TYPE] = "C" ),
    "Type", 'TABLE_A'[AG_TYPE],
    "AC_CODE", 'TABLE_A'[AC_CODE],
    "PCT", 'TABLE_A'[AL_PCT]
)

Then you can establish a relationship between TABLE_B and new table.

Create a calculated column in the new table.

Column =
RELATED ( TABLE_B[OTHER] )

Final output:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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