Forum Discussion

7jaydub9's avatar
7jaydub9
New Member
2 years ago
Solved

Lookup values in other query

Hi All, hopefully someone can guide me in the right direction? i have a query whcih results in this data like this: firstName lastName email course attendedSessionOne       ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi 7jaydub9 

     

    Download PBIX file with the example shown below

     

    With those 2 queries (tables) in Power Query, you can merge them and pull the attendedSessionTwo column into Query1.

     

    Immediately after merging the new column will contain a Table. You just expand these tables (click the double headed arrow at the top of the column) and only extract the attendedSessionTwo column

     

     

     

     

    Where there are peopel who did not atend Session 2, you'll have a null. If you right click on the column header and choose Replace value you can replace these nulls with no

     

     

     

    Regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Hi 7jaydub9 

 

Download PBIX file with the example shown below

 

With those 2 queries (tables) in Power Query, you can merge them and pull the attendedSessionTwo column into Query1.

 

Immediately after merging the new column will contain a Table. You just expand these tables (click the double headed arrow at the top of the column) and only extract the attendedSessionTwo column

 

 

 

 

Where there are peopel who did not atend Session 2, you'll have a null. If you right click on the column header and choose Replace value you can replace these nulls with no

 

 

 

Regards

 

Phil

 

  • 7jaydub9's avatar
    7jaydub9
    New Member
    2 years ago
    Seems so simple when you explain it like that, but guess i still have a lot to learn. Many thanks for this, really appreciate it. J