Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hey all
I am trying to extract test from the string the last but two coulmns (delimiter's)
NPO-63928320-Robert Robert James-6/31/19-DAH NPO-39528320-Li Wang-06/24/2017-SHA NPO-39285320-Xi Nam Suas Aasq-07/23/2017-EKA NPO-3928e320-Rich Braden-05/21/2014-KAM NPO-392y8320-Justine Schimpf-08/21/16-SHAM NPO-39283g20-Nadla Schimpf-02/22/17-ASQ JAPB-39283320-Wang Shang-09/08/2013-ASQ ACDBPO-36928320-Raq Rich-02/07/13-SAW EUAS-392885320-Jillan Dang Romeri Hernadaez-01/07/2017-SLA
So my columns look like these, imported from a xlsx and I want just the names to be seperated, which happens to be inbetween the last but two delimitters. Can someone has way to extract apart from splitting based on delimiter option and using if else? I am looking more like a DAX or a formula way to implement in these.
Hi,
You need something like in this post --> https://community.powerbi.com/t5/Desktop/DAX-extracting-string-using-delimiter/td-p/287840
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 53 | |
| 42 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 106 | |
| 39 | |
| 36 | |
| 27 |