This is from the custom column editor and it says this syntax is fine.
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?
Go to 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
NewColumn = if(LEFT(StudentMarks[Student],1)="j",1,0)
Use like above format
Its obviously a bug that the custom column window says Text.Left is ok so.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.