Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |