Forum Discussion

simona0808's avatar
simona0808
Icon for Helper I rankHelper I
3 years ago

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...
simona0808's avatar
simona0808
Icon for Helper I rankHelper I
3 years ago

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. 

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

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.

  • simona0808's avatar
    simona0808
    Icon for Helper I rankHelper I
    3 years ago

    Unfortunately, I am not able to change it due to customer requirements. Do you know how this can be done using Dax?

    • ValtteriN's avatar
      ValtteriN
      Icon for Community Champion rankCommunity Champion
      3 years ago

      It can be done with dax for example like described in the blog I linked

      • simona0808's avatar
        simona0808
        Icon for Helper I rankHelper I
        3 years ago

        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)