Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
User | Count |
---|---|
84 | |
74 | |
63 | |
51 | |
45 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |