Forum Discussion
Power Query Intellisense giving erroneous results
Hi ddichiera ,
As long as you don't enter the decimal point ".", you enter part of the function, and press Enter will not cause an error.
→
→
If you enter the decimal point ".", it will return the wrong result. This is because of the decimal point you input, the system may think that the code before the decimal point has been entered, and re-matches the relevant function after the decimal point, so two tables will appear.
→
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Stephen, I can kind of get that to work, really tricky.
Problem is, I'm an instructor and getting my students to master that is nigh on impossible. The old "method" worked fine.
Hi ddichiera ,
I think it was designed like this. Allow your students to get used to this operation.
You can find from the figure that if you only enter a ".", the function will exit. When you enter the "table" and then enter the ".", the table in front of the surface has ended, and it has nothing to do with the characters entered after the ".".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ddichiera ,
I think it was designed like this. Allow your students to get used to this operation.
You can find from the figure that if you only enter a ".", the function will exit. When you enter the "table" and then enter the ".", the table in front of the surface has ended, and it has nothing to do with the characters entered after the ".".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
