Power query

[Dain]

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.

[Floriankx]

Hello,

if Text has always the same length then Column=LEFT([Test],13) should simply do the job.

[Dain]

Thank You.

I want this to be done in power query.I am trying to add a custom column.

[Floriankx · Accepted solution]

Hello,

no problem.

Text.Start([Text],13) is the equivalent of the LEFT-function in M.

Best regards.