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