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!
I'd like to remove / trim any text after the hyphen in order to consolidate minor variations in batches. As you can see in the graphic below, there are variations of the batch numbers and I'd like like to remove any text past the hyphen so that there are two batches: B10107 and B10108. I'm bringing in this data from a SQL query, and could address this issue there. However, I'm curious from a Power BI perspective how this could be solved.
Solved! Go to Solution.
Try a new column like
left([batch], search("-",[batch],,len([batch])+1) -1)
Thanks, this worked perfectly.
Try a new column like
left([batch], search("-",[batch],,len([batch])+1) -1)
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |