Forum Discussion
Solved
LOOKUPVALUE to conditional column in Power Query Editor
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 di...
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.
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!