Solved: Re: Merge values in two columns into new column

SamWhite · ‎04-27-2023

I have two columns in excel as shown below:

I want to merge this two columns into a new column using Power Query so that result in the new column called "Final" is like below:

How can i acheive this using power query?

watkinnc · ‎04-27-2023

= Table.AddColumn(PriorStepOrTableName, "Final", each [Req number]?? [Req1 number])

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

watkinnc · ‎04-27-2023

= Table.AddColumn(PriorStepOrTableName, "Final", each [Req number]?? [Req1 number])

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

SamWhite · ‎04-27-2023

Thanks for the response. It works fine. What does the ?? operator do?

Merge values in two columns into new column

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions