Forum Discussion
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 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)
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 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.
3 Replies
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!
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.
how do I create the column in power query? I have been attempting different things but haven't been able to figure it out
