Hi, I am trying to exclusively use Power Query to find the first value in a row greater than greater than 0 Tried the below but doesnt workList.RemoveNulls(List.RemoveFirstN(Record.ToList(_)),3){0} The column i want to start looking from is after 3 Thanks

didnt work - keep getting error Managed to get it to work using this insteatry try List.Select( List.RemoveFirstN(Record.ToList(_), 3), (x) => x > 0 ){0} otherwise 0) THank you though.. first part of the solution worked a treat