Hi
I have the follow code to sum columns in power query;
Please Login or Register to view this content.
This give me the records which can then be inserted; but if I make it dynamic using List Accumulate, there are 'code numbers' in the first column where I want the word "Total", so when I use the following they also get added up, is there a way round this?
is there a way to get it to ignore the first 'Code' column, or use an if statement,Please Login or Register to view this content.
Bookmarks