Power Query, subtraction between two lists

Hi peterhui50 

It's not quite as simple as in R I'm afraid, but you can use List.Zip to combine corresponding elements from a list of lists, then perform operations on the resulting list.

For your example, the code to enter in the calculated column dialog box would be something like this:

List.Transform( List.Zip( {[Numbers_1_3_5], [Numbers_2_4_6]} ), each _{1}-_{0})

 Regards,

Owen