displaying the first x characters 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

[parry2k]

@amitchandak I still don't get it, I know it can happen but why I hardly see it happened from other users. I don't care, you can reply whatever you feel like but was just curious and it un-necessary adds the noise. Anyhow, I will leave it up to you. Good luck!  

[parry2k]

@amitchandak I don't understand what is the point for you to provide the same reply. Don't you notice/see if a reply is already given and there is no point giving the same reply until you have something different? I don't/never understood this.

[littlemojopuppy]

@parry2k I completely agree.  I've posted solutions to topics that included DAX and screen snips showing the output is exactly what was asked for.  And he has replied HOURS later with an identical response.  It's kind of ridiculous.  I thought I was being petty by feeling annoyed by this so I'm glad someone else agrees with me.

Solved: Re: Calculate a running total based on criteria - Microsoft Power BI Community

Re: RANKX and visual level filter - Microsoft Power BI Community

[amitchandak]

@parry2k , when Start typing it did not show me you have replied .I took some time to type the formula and save it. You can see we hardly diff by 1 min.

One of the reason I use @ is that it tell if someoen else has already replied.

[littlemojopuppy]

@amitchandak that doesn't explain you replying to topics HOURS after someone has offered a solution now does it???  🤔

[amitchandak]

@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)

[parry2k]

@Anonymous not sure, add a new column with following expression

New Column = LEFT ( Table[Your Column], 15 ) 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡