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 have the below custom column I would like added, however, I am getting a 'Token ',' expected error showing.
Any ideas what simple thing I am doing wrong 🙂
Text.TrimStart (
Text.Contains([POS PARENT DIVISION NAME],"Area ") then text.end([POS PARENT DIVISION NAME],2)
else "99" )
Thanks
Alex
Solved! Go to Solution.
Hi @villa1980
you forgot the if clause
The following code should work 🙂
Text.TrimStart(
if Text.Contains([POS PARENT DIVISION NAME], "Area ")
then Text.End([POS PARENT DIVISION NAME], 2)
else "99"
)
Hi @villa1980
you forgot the if clause
The following code should work 🙂
Text.TrimStart(
if Text.Contains([POS PARENT DIVISION NAME], "Area ")
then Text.End([POS PARENT DIVISION NAME], 2)
else "99"
)
That is great tank-you so much for the reply, I knew I was missing something so simple
Check out the July 2025 Power BI update to learn about new features.