Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
View solution in original post
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.