The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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