Forum Discussion
TOPN function doesn't allow me to quote a table
Thank you for the prompt feedback. I suspect the issue may relate to my computer language setup or power bi version. Is there a way for me the send you the data and topn function as an attachment rather than a printscreen?
Hi Anonymous
My pbix
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the URL to the pbix sampel file.
I just tried inputting the same measure on a colleagues's power query module (in Excel), which seems to work. I wouldn't like to know why it doesn't work with my power bi desktop.
Thanks!
Hi, just to let you know that I have installed the latest power bi desktop and open your file from there, I got the same error message with your function.
I've had PowerBI act funny becaue of spaces once - try using DAX formatter to format your code, maybe it will help:
