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.
Hi there,
I'm trying to make a measure that takes the number from a field(it is a phone number), dropping the leading number (usually a 0) and then concatenate "353" onto the beginning. For example 0871234567 becomes 353871234567.
The main problem is that I can't seem to figure out why concatenate won't see the fields in the table in its scope.
I've tried various forms of CONCATENATE("353", RIGHT(Table[PhoneNumber], LEN(Table[PhoneNumber])-1)) but it doesn't recognise any of the fields from the table. Pretty sure I'm making a stupid mistake somewhere?
Hi @Mothra ,
Are you sure, you want to use a Measure and not a calculated column? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |