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...
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

      • simona0808's avatar
        simona0808
        Helper I
        3 years ago

        I believe I need to use a SQL query to achieve my goal. Currently, I have a column in my database that contains multiple values per row, as it's derived from a checklist. However, for my Power BI report, I need to use a single value as a page-level filter. To do this, I would like to split the values in this column into separate rows so that each row contains only one value. Can you assist me in creating a SQL query to accomplish this task?