Forum Discussion
Splitting Columns using DAX
I know in SQL there is a way to run queries if certain words are phrases are contained and I am kind of trying to replicate that here.
I have a column called "ShortNote" that lists every automatically system-generated note. Some of the notes contain Assignment information and I need to extract this from the column.
Normally I would split is out by number of characters, but because every Assignee's name has a different number of characters, that doesn't work.
Is there a dax way to write "Split column from 'AssignedTo' to 'the end of the note'"?
I would do this in Power Query using a custom delimiter of "Assigned To".
2 Replies
I would do this in Power Query using a custom delimiter of "Assigned To".
so I think Greg_Deckler saw your mention up front of SQL and recommended a Power Query solution..... but maybe you were just using that as an analogy and maybe the data is not coming from SQL Server - - not sure....
in any case, in Power BI, use the Query Editor option when in data view - and in the ribbon there is the Split Column option which you can use; should be able to use the first space as delimiter assuming that this occurs just after 'AssignedTo' as you have posted.....
