Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
and got that one, too 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.