Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
Solved

Power Query: Access Other Tables at Design Time

So my idea is that as much as possible... do everything in Query Design time.

 

With that, I simply want to create a composite key but this time around based on another table, so instead of me doing:

 

         - New Column

         - LookupValue(PrimaryID(other table),ForeignKeyTableWideID(other table),TableWideID(this table))

 

I'd like to have an equivalent logic in query design mode

        - Add New Custom Column

        - some kind of join???

 

Dummy PBIX: https://drive.google.com/open?id=0Bw37apQUhEqhdmJ0dTBZbVBuS1E

  • Merge Queries is the Answer....  Im all good now... thanks for all those who read this entry.

1 Reply

  • ovetteabejuela's avatar
    ovetteabejuela
    Impactful Individual

    Merge Queries is the Answer....  Im all good now... thanks for all those who read this entry.