Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |