Forum Discussion
Solved
Create a Custom Column based on multiple columns
Hello, I'm trying to create a custom column (column E) that evaluates columns A through D to find cells with a whole number that is greater than or equal to 0 and puts that number into column E. If t...
Hi jiexika24
Thanks fot your quick reply, you can refer to the following steps.
In power query, select all columns, then select 'Merge column'
Then you can input the new column name
After merging, change the column type to whole number.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
= [A] ?? [B] ?? [C] ?? [D]
--Nate