Forum Discussion

mixue100's avatar
mixue100
Frequent Visitor
4 years ago
Solved

Creating a virtual table with columns from different tables

Hi   I would like to create a virtual table by pulling out columns from different tables. Please see screenshot or attached for the sample. How can I proceed to do so ?    I tried cross join but...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mixue100 ,

     

    Maybe you can use Power Query Eidtor to create this table.

    Merge Queries as New.

    Remove the columns we don't need and  Enable load table to  the desktop.

    Attach the pbix file for reference.

    Hope it helps.

     

    Best Regards,

    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mixue100 ,

 

Maybe you can use Power Query Eidtor to create this table.

Merge Queries as New.

Remove the columns we don't need and  Enable load table to  the desktop.

Attach the pbix file for reference.

Hope it helps.

 

Best Regards,

Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!