I have an extensive Access background and am being "forced" to transition our databases to Excel. I'm trying to teach myself power query in Excel and am cringing over how much more effort it seems I'll have to go through to even create basic queries. As a hypothetical example, say I have two tables. One is a list of employees. That table lists the employee id, employee name, and their status code of A, L, or T. I also have a status table with the descriptions for A, L and T. A's description is Active, code L is Leave and T is Term. I have figured out how to add both tables to a data model in Excel and have related the status code on the table of employees to the status code on the the status code table. What I can't figure out how to do is how to bring in the description from the status table. Not sure what I'm missing and would appreciate any help. Thanks!
Bookmarks