Forum Discussion

Dain's avatar
Dain
Frequent Visitor
8 years ago
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 auer...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    no problem.

     

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

     

    Best regards.

Dain's avatar
Dain
Frequent Visitor
8 years ago

Thank You.

 

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

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello,

 

no problem.

 

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

 

Best regards.