Forum Discussion
Shortening a string in a column
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
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)
2 Replies
- amitchandak
Super User
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)