Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
148
Views
Topic starter
Expression.Error: We cannot apply operator & to types Number and Number.
Details:
Operator=&
Left=2021
Right=8115
Left value is a year & Right value is a Ticket number. And both share the same Data type number (1.2). I dont know what I'missing.
Posted : 27/11/2021 6:01 am
Hi Sunny,
When you use & you're concatenating and to concatenate the data type must be text. You cannot concatenate numbers. First change the data type to text.
Mynda
Posted : 27/11/2021 6:18 am
Topic starter
Thank you so much! On top of that I really want to thank you for you quick response. You're awesome!
Posted : 27/11/2021 9:00 am