New column in new table based on values of other tables

Anonymous — Wed, 03 May 2023 06:49:08 GMT

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

Table 2

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:

Re: New column in new table based on values of other tables

Mahesh0016 — Wed, 03 May 2023 13:16:12 GMT

Anonymous 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]

)