Forum Discussion
Dax trim function
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/
Thank you very much for your answer! Thats what I want. I tried your approach but it says that it cant be applied in direct query mode.
In Directquery mode I am pretty sure this won't work and you will have to use dax option. If possible try changing your conenction to import/composite model then the original soltuion I provide should work.
Unfortunately, I am not able to change it due to customer requirements. Do you know how this can be done using Dax?
It can be done with dax for example like described in the blog I linked