Forum Discussion

joooffice's avatar
joooffice
Helper I
5 years ago
Solved

Add index column with if statement

I currently add an index column that pulls the starting figure from the results of another query called Last Submission ID which works fine.   = Table.AddIndexColumn(#"Sorted Rows", "Index", #"Last...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    joooffice , you might want to try

    = Table.AddIndexColumn(#"Sorted Rows", "Index", (#"Last Submission ID"??0)+1, 1)
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

joooffice , you might want to try

= Table.AddIndexColumn(#"Sorted Rows", "Index", (#"Last Submission ID"??0)+1, 1)