Forum Discussion
Create a calculate column with LEFT function using power Query IN a liveconnection
Hello everyone In my database i wanted to join By just the left part of the CONTRACT column I use a directQuery with my database so i couldn't split the column by delimiter , so i tried to C...
thank You very Much that was so helpful .
i have another Question , i mentioned that i'm using a directQuery is it possible somehow to split a column ?! because i tried to use the function Text.Start it works but i have an error " This step results in a query that is not supported in DirectQuery mode."
Hi Anonymous,
Using the direct query adds limitations to the data handling in Query Editor.
Check this documentation with the full details.
You need to make a DAX column, in practice this does not change anything in the way you handle it to do measures or visuals, the only impact is that this column will no appear in the query editor.
Regards,
MFelix