Forum Discussion

jimmyhua's avatar
jimmyhua
Icon for Helper I rankHelper I
1 year ago
Solved

use List.Generate to create a conditional index gave me Expression.Error

I tried to create a conditional index for another list I created. here is the code I wrote and error I got.  The first list is to create a position indicator where the index can began. The first one ...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    use the below formula

    let
    Source = {1,1,2,3,1,2,1,2,3,4,5,1,2,3,1,1,2},
    Custom1 = List.Transform(List.Positions(Source), each if Source{_}=1 then _+1 else null)
in
    Custom1

    result in 

     

     

     

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
1 year ago

the result of Splitposition is a list and
in this part

_ >= Splitposition

 

you can not compare a number (_) with a list (Splitposition).

 

you can replace it by _ >= Splitposition{0}

but if you explain the purpose of your function I can help you more