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...
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
I tried to implement the steps from the tutorial however I encountered an error that pathlength is not a function and can be used in a direct query mode( again the same problem)