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
Solved! Go to 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 , 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)
Thank you! didnt know about text.start
User | Count |
---|---|
103 | |
83 | |
68 | |
47 | |
47 |
User | Count |
---|---|
155 | |
91 | |
82 | |
69 | |
67 |