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:
![](http://powerbikiss.com/wp-content/uploads/2022/03/image.png)
Try searching without the dot, like this:
![](http://powerbikiss.com/wp-content/uploads/2022/03/image-1.png)
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