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 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.
ty. You are right, it looks like not supported but i dont undestand why. I moved from Excel 2013 to Excel 2016 but not updated?
btw i think that was the problem
ty again
bye
Luca
Luca, with O365 it shall be fresh version after the update. If you share your version from here
it'll be more clear how old is it. In opposite to PQ the history of office versions is available.