Power query intellisense can be really frustrating to use, but there is a simple solution…
No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this:

Try searching without the dot, like this:

You will quickly find the formula you need & when you tab to accept, it will work as you would expect.
This quick video covers it too…
0