Shortening a string in a column

[Anonymous]

Hello, so I have a column that has this super long string of text, and I was wondering if I could shorten it to say the first 15 characters or so somehow? I have tried using the LEFT function to write a measure but I can't use the column in that, only other measures. And there is no left function available when I try adding a column. Thank you

[amitchandak · Accepted solution]

@Anonymous , in a column

new column = left([col1],15)

In power query you can use text.start

https://docs.microsoft.com/en-us/powerquery-m/text-start

Text.Start([Col1])

in measure

New measure = left(Max(Table[Col1]),15)

[Anonymous]

Thank you! didnt know about text.start