Forum Discussion

grawri's avatar
grawri
Frequent Visitor
8 years ago
Solved

Create Calculated Column from Related Table

2 tables related via the Account ID column. Table 1 is a dimension table (GL Accounts) and has over 100 rows. Account ID Account Name ...   5-1000 Wages 5-1200 Contra...
  • Anonymous's avatar
    Anonymous
    8 years ago

    grawri,

    Please use DAX below.

    Column = LOOKUPVALUE('GL Accounts'[Account Name],'GL Accounts'[Account ID],Remuneration[Account ID])



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

grawri,

Please use DAX below.

Column = LOOKUPVALUE('GL Accounts'[Account Name],'GL Accounts'[Account ID],Remuneration[Account ID])



Regards,
Lydia

  • grawri's avatar
    grawri
    Frequent Visitor
    8 years ago

    Thank you so much Lydia.  Perfect.