Forum Discussion

simona0808's avatar
simona0808
Helper 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...
ValtteriN's avatar
ValtteriN
Community 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
Helper 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
    Community Champion
    3 years ago

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

    • simona0808's avatar
      simona0808
      Helper 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)

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi simona0808 ,

        What type of data source are you worked on? If you mean SQL or other type of Datasources which support T-SQL queries, I’d like to suggest you turn on the 'advanced option' -> 'SQL statemen' options in data connector to use custom T-SQL query to handle these conversions.

        Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

        Regards,

        Xiaoxin Sheng