topic Re: How to get the word between 2 underscores in DAX Commands and Tips

How to get the word between 2 underscores

haykp — Mon, 22 May 2023 17:28:25 GMT

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

Re: How to get the word between 2 underscores

tackytechtom — Mon, 22 May 2023 18:07:37 GMT

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/

Re: How to get the word between 2 underscores

haykp — Tue, 23 May 2023 15:07:17 GMT

Thank you!

This solution is very good.

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

Thanks

Hayk

Re: How to get the word between 2 underscores

tackytechtom — Tue, 23 May 2023 15:38:39 GMT

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/