Forum Discussion
Dax trim function
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
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?