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.
Hello everyone ,
I have a table coming from analysis services (so no PowerQuerry unfortunately....) and I want to remove every letter from a string:
and the result should be something like:
30
33
Is that even possible through measure calculation?
(Consider that there might be cases that we have more that 1 letter in the beginning of the row, or more than 1 letters at the end of it)
Thanks
Solved! Go to Solution.
@akampianakis well, you could force him with SUBSTITUTE, even though that would be a little stinky. I would need at least 26 of those statements
https://docs.microsoft.com/en-us/dax/substitute-function-dax
@Anonymous
You cannot remove or replace the current column using DAX, beside you are using Live connection mode, you can only create measures. For you case, try connect to AS model with import mode and using Power Query something like:
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","C","",Replacer.ReplaceText,{"Column"})
However, you might need to do that for each letter.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@akampianakis well, you could force him with SUBSTITUTE, even though that would be a little stinky. I would need at least 26 of those statements
https://docs.microsoft.com/en-us/dax/substitute-function-dax
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |