Forum Discussion
Conditional columns and null values
I am transforming data from Dataverse, and I have rows that look like this: Field1 Field2 ABC null null DEF GHI null I want to create a new column to combine these two: Fi...
Hi DavidS-RI
You can use List.Max() function, you can create a custom column.
List.Max({[Field1],[Field2]})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.
This did not work for me. The value of the custom column was Error for all rows.
