Forum Discussion
StephenF
Responsive Resident
Responsive ResidentExpression.Error: The name 'Text.Left' wasn't recognized. Make sure it's spelled correctly.
This is from the custom column editor and it says this syntax is fine. Syntax if ((Text.Left([BRN],3) ="RNN") and Text.Contains([Programme Name]," 2019-")) then 1 else 0 Yet this cause an...
As far as I know there is no Text.Left in Power Query. Try Text.Start instead: https://docs.microsoft.com/en-us/powerquery-m/text-start
As far as I know there is no Text.Left in Power Query. Try Text.Start instead: https://docs.microsoft.com/en-us/powerquery-m/text-start
StephenFResponsive Resident
Responsive ResidentIts obviously a bug that the custom column window says Text.Left is ok so.