Forum Discussion

Porkey's avatar
Porkey
Frequent Visitor
4 years ago
Solved

List.Generate shows an error but i cant find the e

Hi    this is the error shown I then get a full table of results when i transform to a table (showing no errors in any rows (it works perfectly as intended)   Code for the list.generate is...
Need Help
  • Porkey's avatar
    Porkey
    4 years ago

    Thank you for the advice it turned out to be 

     

    each [CR] < List.Max(#"Rota_Data (2)"[Index]),

    I needed to amend it to NR instead as CR did not reach the maximum value until one step after the end

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I can't tell precisely where the problem is but I'm betting it's an off-by-one indexing error where you're trying to pull 

#"Rota_Data (2)"{CR}[ColName]

where CR is greater than the maximal index of Rota_Data (2).

  • Porkey's avatar
    Porkey
    Frequent Visitor
    4 years ago

    Thank you for the advice it turned out to be 

     

    each [CR] < List.Max(#"Rota_Data (2)"[Index]),

    I needed to amend it to NR instead as CR did not reach the maximum value until one step after the end