Forum Discussion
Dax trim function
Hello everyone, I am working on a project and I would like to ask for some help. As you can see in the image the left column(injured body parts) is coming from a checklist and is stored in a list s...
Hi,
I am not 100% I follow but I assume you want to separate the list using ;# as delimiter and have the results show on different rows?
If you have access to powerquery I recommend doign this there like this:
Right-click and select "split column by delimiter" -> Select custom and enter ;#
Select created column and unpivot:
In dax you can do with e.g. using substitute function and some tricks. Here is an example blog of this by entreprisedna: Power BI Split Column By Delimiters In DAX (enterprisedna.co)
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/