Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
I am getting this error when making a custom column the syntax is accepted and closes, when I look at the column it has errors which reference the error message in the subject above.
Using custom column in PQE, I entered = Table.AddColumn(#"Added Campaign Class", "Custom", each if (not Text.Contains([Name], "Europe") and Text.Contains([Name])=" uk car sale") then " uk car sale" else "no")
I want a column that will tell me where the name is not europe but contains uk car sale then label this as uk car sale
any ideas on what I am doing wrong here ?
Solved! Go to Solution.
Thanks Antriksh this seems to have worked !