Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Expected Token RightParen

Good Morning,

 

Im stuck again and if anybody has a hint for me, it would be much appreciated.

In Power Querry Im Trying to do a new column for my client.

It should have the first two letters of the land and if the land is DE it should have a dash and the first two digits of the Postal code (PLZ). This is what I tried:

 

each if [LAND] = "DE" then Text.Combine({Text.Start([Land],2),"-",Text.Start([PLZ],2)}) else Text.Start([Land],2)

 

But I always get:
Expression.SyntaxError: Erwartetes Token: RightParen.

"Expected Token Right Paren"

Didnt find much about it on the Internet and hope someone here knows what Im doing wrong.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

ok I found the error, I wrote the first "Land" in all uppercase.

Formula still doesn't work, I get the Land correctly, but I dont get the dash and the postal code.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

ok I found the error, I wrote the first "Land" in all uppercase.

Formula still doesn't work, I get the Land correctly, but I dont get the dash and the postal code.

Anonymous
Not applicable

and got that one, too 🙂

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors