Forum Discussion
DirectQuery way to do something like Text.BetweenDelimiters?
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.BetweenDelim...
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.
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