Add an index starting from a value in another column

[Kamel_el]

Hi All, 

I would like to add an Index in my Query but I want it to start from a value available in another column. 

I'm not sure what I should add in the advanced editor to ask to start from a specific value available in column X

Has anyone ever tried to do this please ? 

Thank you

Kamel

[v-cgao-msft · Accepted solution]

Hi @Kamel_el ,

May I ask if you want something like this? When 'Keyword' appears in [Column1], [Index] + 1.

If so, please refer to the solution in this thread.

Solved: Index column only for specific value

If I have misunderstood your needs, please feel free to contact us.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[ppm1]

Please provide a few example rows of data to show what you mean. What is the logic to decide which value in the X column is used to start the index?

Pat