The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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