Forum Discussion

erhang's avatar
erhang
Helper II
8 years ago
Solved

Counting lines

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 

 

 

 

 

 

Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    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

3 Replies