Referencing a linked table column in a calculated column formula RRS feed

  • Question

  • Hi,

    I have built a data model with two tables and they are connected via a column (PositionID). The first table (T1) is pulling data from a SQL Server and the second tables (T2) is a linked table from Excel. I need to create a calculated column in T1 where it checks a condition in T1 and then depending on the value it should grab a value from T2 to do the calculation (similar to VLOOKUP I guess). It seems like I cannot have column from T2 as part of calculated column in T1, is that correct? If so, what is the solution? 

    Wednesday, November 27, 2019 8:41 PM


  • Hi,

    Just create column in T1:

    • Proposed as answer by Darren GosbellMVP Thursday, November 28, 2019 11:31 PM
    • Marked as answer by AV111Editor Monday, December 2, 2019 5:56 PM
    Thursday, November 28, 2019 10:32 AM