Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
55 | |
37 | |
32 |
User | Count |
---|---|
71 | |
65 | |
60 | |
50 | |
45 |