cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

7 REPLIES 7
parry2k
Super User III
Super User III

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

amitchandak
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

parry2k
Super User III
Super User III

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

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors