Forum Discussion
M Language Syntax problem from Excel 2013 to 2016
LucaA1 , I didn't find the version history, but 2.49 is mentioned more than an year ago. Text.Select also was introduced about an year ago. Perhaps your version is bit old.
You may check if function is supported or not in your version. Start blank query, in formula bar type
= #shared
and you will see list of all supported for your version functions. Better to transform that list into the table and sort ascending - it'll be easier to check.
LucaA1 , I may only repeat the screenshort from here https://community.powerbi.com/t5/Desktop/M-Language-Syntax-problem-from-Excel-2013-to-2016/td-p/684472 but made in Excel Power Query - it works. Moreover, if you type it in formula bar and have no such error that's not the syntax of the function itself. Most probably that's what around it. If you could provide small sample file it'll be easier to say what that could be.
Data of that model are sensitive, but i am gonna share this other book with a sample, and text.select still doesn't work.
Can you help me?
thanks
Luca
LucaA1 , I was no able to reproduce, just refreshed and it works (attached). If you check here
what is your Power Query version?
LucaA1 , I didn't find the version history, but 2.49 is mentioned more than an year ago. Text.Select also was introduced about an year ago. Perhaps your version is bit old.
You may check if function is supported or not in your version. Start blank query, in formula bar type
= #shared
and you will see list of all supported for your version functions. Better to transform that list into the table and sort ascending - it'll be easier to check.