Power Query, Copy Entire Table only copes 1000 rows

LanaPow 

only 1000 rows is not an error.

there are two mode of data view:

power query (power editor) is the only PREVIEW of data. it helps you to understand what data modification  you need to do for your business logic achievement

in the normal mode (where you are seeing the correct max value) each of your rows (more then 1000) participatec in your calculation

dont worry, calculations are gonna be good, even if in power editor mode dont see all your data

do not hesitate to give a kudo to useful posts and mark solutions as solution

Hi az38 

ok i've explored around a bit, and i found that i can export the data from this visual into a file ))))

it's really cool how you answered, made me do some foot work but also helped ))

Thank you!