Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a string column with values like:
jkasdjadsj (sdsa) (111)
adkhsjd (343)
FDADasas (asda) (323)
I want to extract the "letter part" to have:
jkasdjadsj (sdsa)
adkhsjd
FDADasas (asda)
In SQL I would find the position of the bracket that is followed by a numeric character LIKE "([0-9]%"
What can I do in DAX? How to differ those brackets?
Solved! Go to Solution.
Hi @AnetaK,
If all values in this column are formatted like "xxxxxxx (111)", you could try below DAX formula to create a calculated column:
Column3 = SUBSTITUTE(Sheet2[Column1],RIGHT(Sheet2[Column1],5),"")
Best regards,
Yuliana Gu
This is how it lookes like.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |