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

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?