Counting lines

[erhang]

Hi there ;

i want to count one of column and want to give number  them wit a new column.Which formula that i can use , could you help me pls.

in below example i want to create "number" column whic is marked red..

but pls be attention that first line will start a specific number is "10.000.001" 

thanks for your supports 

[quentin_vigne · Accepted solution]

Hi @erhang

You need to go to the data tab, then go to edit query / power query editor - Add new column

Then you can add Index column from 10000001 with an increment of 1 for example

- Quentin

[erhang]

thanks for the solution dear @quentin_vigne

[quentin_vigne]

@erhang

You're welcome