The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Thank you!
This solution is very good.
Just one issue, after split the inital column is lost. Can I keep it?
Thanks
Hayk
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
18 | |
16 | |
13 |
User | Count |
---|---|
41 | |
38 | |
23 | |
21 | |
19 |