DirectQuery way to do something like Text.BetweenDelimiters?

[Anonymous]

Hello,

I have a DirectQuery database that is pretty large, so I can't do the import. I have been attempting to add a column to my table in PowerBi and it keeps saying when I use Text.BetweenDelimiters that it results in a query not supported by DirectQuery. In my table I have a text note that is formatted to a pattern, and I am attempting to grab the date from a specific portion of the note so that power BI can use that date as a filter. 

I am new to DAX so I might be missing a function that I can use in DirectQuery and my search didn't result in any options that are supported. Anyone able to help? Or is this just impossibile using directquery?

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you?

Best Regards!
Dale

[Anonymous · Accepted solution]

I don't think its possibile with Direct Query. I want to do something with M and Text between delimiters, nothing worked I kept getting an incompatibility message. In DAX where the screenshot is, it also gave me warnings about even Find. Eventually I did get that to work by allowing incompatible querys in the settings menu. But, it didnt work exactly as I intended.

[v-jiascu-msft]

Hi @Anonymous,

It seems you used a Power Query function rather than a DAX function. What's the patten of the column? Than we can find a DAX function here. The LEFT, RIGHT and MID could help. Please gave a sample.

You can add a new column as the picture shows.

Best Regards,

Dale