How to get the word between 2 underscores

[haykp]

Dear Power Bi Community,

Please help me with my first steps in DAX.

So I have a file name which has different words all connected with underscores ("_"). Somehting like this:

sales1_germany_tests_lcd_2023_W17

How I can parse and get each of the words in seperate column. In other words, what I need is some DAX expression which can return me the Word between the "_" symbol:  i.e. _<Word>_

and my final result should be

sales1  

germany

tests

lcd

2023

W17

Can someone please share some hints about DAX?

Thanks

Hayk

[tackytechtom]

Hi @haykp ,

Glad to hear! Just copy the column that you wanna keep before you do the split. You can do this by adding a new column and just refer to the original one.

let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom · Accepted solution]

Hi @haykp ,

Before

Power Query is perfect for what you would like to achieve!

Before:

After:

Here how to do it:

If you really want to use DAX for this, consider the following blog post:

Power BI Split Column By Delimiters In DAX (enterprisedna.co)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[haykp]

Thank you!

This solution is very good. 

Just one issue, after split the inital column is lost. Can I keep it?

Thanks

Hayk