Forum Discussion

viveksasi94's avatar
viveksasi94
Helper I
7 years ago

How to extract a text in a column in Direct Query mode

Hi All, I have a column with a TEXT data type. I need to extract a string after a delimiter from this column in DIRECT QUERY mode. As FIND and SEARCH is not supported in direct query mode for ca...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI viveksasi94,

 

AFAIK, most of dax functions not work on calculated column when you works on direct query mode.

In my opinion, I'd like to suggest you to use measure to instead.(notice: turn on 'allow unrestricted measures in directquery mode' option to use more dax functions in measure)

 

Regards,

Xiaoxin Sheng