Replicate SUMPRODUCT in Power Query Today I stumbled upon the M function List.Zip which I thought would provide a valid alternative to my previous post about replicating SUMPRODUCT in Power Query. According to Microsoft Power
Tag Archives: Power Query Sumproduct
Replicate SUMPRODUCT in Power Query In my previous post, MMULT in Power Query, I showed how to recreate Excel SUMPRODUCT using List.Generate. This post will show an alternative method using List.Accumulate. Power Query does not come