New column in new table based on values of other tables

[a22]

Hello, I tried posting on here earlier but can't see it anymore. Say I have two tables, Table 1 and Table 2.

Table 1

Shop	Year	Line item	Value
Shop A	2022	current assets total	307125
Shop B	2020	CA total current assets	19076

Table 2

Line item	New name
CA total current assets	Total current assets
current assets total	Total current assets

For context, I am using table 2 to rename the line items in table 1. How do I use DAX to make a new table, Table 3, that looks like:

Shop	Year	Total current assets
Shop A	2022	307125
Shop B	2020	19076

[Mahesh0016 · Accepted solution]

@a22  Power Bi Desktop > Go to Modeling tab > Click On New Table > Paste  this code.

Table C =

SELECTCOLUMNS (

    'Table A',

    "Shop", 'Table A'[Shop],

    "Year", 'Table A'[Year],

    "Total current assets", 'Table A'[Value]

)