Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
i cant figure out why i am getting this problem after passing from excel 2013 to 2016.
The syntax seems correct and also PQ editor says that it is fine but then the step is considered wrong.
=Text.Select(Text.Start([IdRisorsa],2),{"A".."Z"})
The formula worked perfectly in excel 2013 then, with the passage to the new version, it started giving error. The error is "Expression.Error: The name 'Text.Select' wasn't recognized. Make sure it's spelled correctly."
Moreover the exact same formula works on another PC. I cant understand what is going on. If i insert the formula in formula bar everything is ok.
pls help really important.
Solved! Go to Solution.
Hi @LucaA ,
I tested above M function in my Excel 2016, it worked fine.
This problem looks more related to Excel itself. I would suggest you post a thread on Excel forum for help.
Best regards,
Yuliana Gu
Hi @LucaA ,
I tested above M function in my Excel 2016, it worked fine.
This problem looks more related to Excel itself. I would suggest you post a thread on Excel forum for help.
Best regards,
Yuliana Gu
thanks, i will try there.
Bye
Luca