Expression.Error: The name 'Text.Left' wasn't recognized. Make sure it's spelled correctly.

[StephenF]

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?

[sivapandi]

NewColumn = if(LEFT(StudentMarks[Student],1)="j",1,0)

Hai.,

Use like above format

[Anonymous · Accepted solution]

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.