Splitting Columns using DAX

[bhmiller89]

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'"?

[CahabaData]

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

[Greg_Deckler · Accepted solution]

I would do this in Power Query using a custom delimiter of "Assigned To".