Forum Discussion
PowerQuery - Creating consolidation column referencing one of two columns based on third column
Hello! I'm trying to create a consolidation column where the value is either the row value of Column 1 or the row value of Column 2 based on the row value in Column 3. The data might look like ...
if [Col3]=1 then [Col1] else [Col2]
You can add a conditional column as shown in the attached file.