Power Query multiply Column list by row valuus

[Dicken]

Hi, I would be interested in ways to achieve a column by row multiplication in excel SUM( TRANSPOSE( {2;3;4} ) *{1,1,0})*5 = 25

I have done this through Table to rows and then zipping them together and taking the product, but would like to know if there is a simpler way especially using unpivot which I have tried but end up with more steps than the original, which is;

Please Login or Register  to view this content.

I have included this a step by step version along with a unpivot, if anyone has ideas as a way to get the result without a lot of nested lists I would be interested.

Richard.

[romperstomper]

A bit brute force:

Please Login or Register  to view this content.

[Dicken]

Thanks , that is more like what I was trying for, the nested list transforms took me a while to get right.
I will leave it open for the moment and I'd be interested if anyone has any ideas regarding unpivot.

Richard.