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
sivapandi
Helper I
Helper INewColumn = if(LEFT(StudentMarks[Student],1)="j",1,0)
Hai.,
Use like above format