Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost 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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
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.

  • ValeriaBreve's avatar
    ValeriaBreve
    Icon for Post Partisan rankPost Partisan
    4 years ago

    Hello, thanks a lot! This is a really neat way of doing it. However, unfortunately in my case it is not so efficient as I am doing all transformations in DAX, so these tables do not exist in PowerQuery. But I will definitely remember this for the time where I have everything in the query editor 🙂