28 - Coalesce is a simpler way to find the first non-null column (Power Query)
Power Query has access to the "coalesce" function found in SQL-server (and probably other SQL-versions too).
Instead of writing the word "coalesce", you use double question marks ("??") between the parts of your calculation.
The function says: If the value in this column is NOT null, grab that value. If it IS null, grab the value to the right of the double question marks.
Just like with IF functions, coalesce can be chained, as shown in the video.