Forum Discussion
Solved
Power query
Hi All
A small doubt
I have column having
Cyz_20180907043000
I want take the substring Cyz_201809070 from the above text value.
I know this can be done in DAX.
But I want this to be done in auery editor using custom column.
A small doubt
I have column having
Cyz_20180907043000
I want take the substring Cyz_201809070 from the above text value.
I know this can be done in DAX.
But I want this to be done in auery editor using custom column.
Hello,
no problem.
Text.Start([Text],13) is the equivalent of the LEFT-function in M.
Best regards.
3 Replies
Hello,
if Text has always the same length then Column=LEFT([Test],13) should simply do the job.
