Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
4 years ago
Solved

Help with virtual tables

Hi, I am trying to build a virtual table and lookup a valu e from a column of it. I have 2 tables that have a relationshio through the "Concx" field. I want to be able to add columns in the secon...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi ValeriaBreve ,

     

    I would prefer that you use power query to achieve this result.

    Copy the po1 table and pivot the Rank field of this table,like this screenshot

    result:

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

HI:

For a new table you can try = SUMMARIZE('Table 2',
                                               'Table 2'[PO2], 'Table 2'[conc2], 'Table1'[PO2],  etc  ) just add table name and column for other columns. SUMMARIZECOLUMNS is good as well and you don't have to list a table name to begin like in SUMMARIZE. Just Table[Columns].

 This could be a start.