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 error on save.
Is this a bug?
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
3 Replies
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
- StephenF
Its obviously a bug that the custom column window says Text.Left is ok so.
sivapandiHelper I
NewColumn = if(LEFT(StudentMarks[Student],1)="j",1,0)
Hai.,
Use like above format
