LOOKUPVALUE to conditional column in Power Query Editor

[laurahoff97]

I have two data sets that are connected through a column. Through that connection I was able to do a LOOKUPVALUE column creation and move data from one table into the other. Example below, because directors lined up I was able to add a new column to the requests table from the personnel table using (example photos in excel but work took place in powerbi)

Leader Email = LOOKUPVALUE(Personnel Mapping[Leader Email], Personnel Mapping[Director], Requests[Director]).

The requests table is my main table so I want to continue working there. From this new leadership email column brought in I want to create conditional columns in power query editor but because the new leadership email column is just a regular new column calculation in powerbi desktop, it is not showing up as an option in power query editor as a column name when I go to add a conditional column. 

Is there a way I can preform this so that I can add conditional columns based on the newly added column pulled from a separate table?

[laurahoff97]

I did merge queries, selected the two columns that matched and a new column appeared in my requests table that included all columns from the personnel table. Following that I filtered it down to the one column I needed and then the results were the same from lookup value and can be filtered on the email values. Thanks for your help!

[Greg_Deckler · Accepted solution]

@laurahoff97 DAX calculated columns happen after Power Query processing and thus will not show up in Power Query Editor. You would need to create that column as part of a query in Power Query Editor. Probably via a Merge step.

[laurahoff97]

how do I create the column in power query? I have been attempting different things but haven't been able to figure it out