group by function in power query

bercier

New Member
Joined
Mar 20, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
hello,

I have loaded and converted over 300 text files in power query Excel 2016. Now I have about 1M lines that I am trying to do an aggregation on sum and count based on 2 criterias. I am running into some performance issues, it shows that my file is loading data for the last half hour but no rows are loading. Is there a way to help performance for the computer to complete this task?

thank you
sylvain
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,426
try to use Table.Buffer() but without M-code I can't say more
Buffers a table in memory, isolating it from external changes during evaluation.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,939
Messages
5,575,122
Members
412,648
Latest member
errollflynn
Top