Position of the first number in a list lower than n

[p45cal]

If I have:

let
    Source = {7,7,6,4,7,3,4,4,5,1},
    Posn = List.PositionOf(Source,4)
in
    Posn

I get 3.
What I really want is (air code)

    Posn = List.PositionOf(Source,<6)

that is the position of first occurence of a value less than 6 (the return being 3).
How?

Ancillary question: Can I do it from the end of the list instead of from the beginning, ie. the last number less than 6 in the list?

 

[Bob Phillips]

This should do it

     Posn = List.PositionOf(Source, List.FirstN(List.Select(Source, each _ < 6), 1){0})

If you want from the end, reverse the list, List.Reverse

 

[p45cal]

That'll do nicely, thank you!

This should do it

 

[Bill Szysz]

There is a function List.PositionOfAny. See the picture below.

 

[p45cal]

Prompted to play around further,

Posn=List.PositionOfAny(List.Transform(Source,each _ < 6),{true},0)

copes with possibilities of negative numbers and decimal numbers and means no arithmetic needed to find the last position in the original list having found the position in a reversed list.
Is it heavier on resources, or slow, or bad practice?

I had looked at PositionOfAny but mistakenly thought the 3rd argument was the 1st, 2nd, 3rd, 4th occurence, not an Occurrence.Type of first, last and all.
Where can I get something like intellisense as in Bill's picture? When writing formulae in a spreadsheet cell you get prompted:

as well as in the VBE.

 

[Bob Phillips]

There is a function List.PositionOfAny. See the picture below.

Bill, your picture is missing. I accidentally deleted this post (I was deleting the posts of some idiot who posted the same post to every forum), and although I undeleted it I think that caused the image to go. Could you be so good a to re-post it?

 

[Bob Phillips]

Prompted to play around further,

Posn=List.PositionOfAny(List.Transform(Source,each _ < 6),{true},0)

copes with possibilities of negative numbers and decimal numbers and means no arithmetic needed to find the last position in the original list having found the position in a reversed list.

A better way in my original suggestion would be to use List.LastN rather than reverse it as I suggested (although I also agree Bill's suggestion of List.PositionOfAny is better).

 

[Bill Szysz]

Could you be so good a to re-post it?

As you wish, Bob )

 

[Bill Szysz]

Where can I get something like intellisense as in Bill's picture?

This was done in excel (manually)
but....look at this post https://community.powerbi.com/t5/Co...-Power-Query-Editor-using-Notepad/ba-p/146347
At the end.... there are many ways to do what you need... i strongly recommend trying each one before choosing (performance)
At the end of the end... one more piece of code to do the same

= List.Count(List.FirstN(Source, each _ >= 6))

 

[Bob Phillips]

Thanks for that Bill.

Your 'intellisense' is a lot better than the documentation, which describes the occurrence argument as

occurrence: The maximum number of occurrences that can be returned.