can I split a column by a delimiter in Power BI DirectQuery mode?

[Anonymous]

can I split a column by a delimiter in Power BI DirectQuery mode?

how?

calculated column?

measure?

power query editor?

advanced editor?

Splitter.SplitTextByDelimiter("=") ?

thanks.

[Anonymous]

you mean: use Import mode?

[lbendlin]

No, use DQ with local data model.

[lbendlin]

The result of your transforms must have the same structure.  If your column sometimes splits into two, and sometimes into three columns you will get an error message .

Better to use DAX if you need to act on the content inside the column.