Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dax

Hi everyone,   I have some issues about creating a new table,    I have 3 sheets from Excel and I have loaded into Power BI.   Sheet1 and Sheet2 are including with Name, Date and Balance, so th...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    You could try this:

    FinalTable =
ADDCOLUMNS (
    UNION ( Sheet_1, Sheet_2 ),
    "Age", LOOKUPVALUE ( Sheet_3[Age], Sheet_3[Name], [Name] )
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

You could try this:

FinalTable =
ADDCOLUMNS (
    UNION ( Sheet_1, Sheet_2 ),
    "Age", LOOKUPVALUE ( Sheet_3[Age], Sheet_3[Name], [Name] )
)

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks! It works out!