Forum Discussion
jimmyhua
Helper I
Helper Iuse 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 ...
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 Custom1result in
jimmyhuaHelper I
Helper II would like to be able to create a list2 like this based on list1
{1,2,null,null,5,null,7,null,null,null,null,12,null,null,15,16,null}
Omid_Motamedise
Super User
Super Useruse 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
Custom1result in