Forum Discussion
QUERY EDITOR (Not Desktop) Replacing cell counts with Cumulative Totals
I originally wanted to know how to create a calculated column to accomplish this. I was given the following code and it worked in desktop mode but not in the query editor. Running = SUMX( ...
Greg_Deckler
Community Champion
Community ChampionYou are correct, Query Editor uses Power Query "M" Language which is entirely different that the DAX language used in "Desktop".
https://msdn.microsoft.com/en-us/library/mt211003.aspx
And, as it turns out, not NEARLY as easy to do in M as in DAX:
http://www.excelguru.ca/blog/2015/03/31/create-running-totals-in-power-query/
Thanks for clearing that up. Im going to give this a shot. I've never used the M language before.