Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@amitchandak that doesn't explain you replying to topics HOURS after someone has offered a solution now does it??? 🤔
@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 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |