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.
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