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.
Hi Dears,
I need to display around the first 600 characters of a long text field but the left function truncate the word sometimes.
How can I get left part of a long text but get the last full word after a certain position.
Best regards,
Augusto
Solved! Go to Solution.
hi @Anonymous
you can try something like this
someColumn =
VAR _currentString =
CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
RIGHT ( _currentString; LEN ( _currentString ) - 600 )
VAR _firstSpace =
SEARCH ( " "; _rightPartOfString ) - 1
RETURN
LEFT ( _currentString; 600 + _firstSpace )
This code expands the left function to the first space after character number 600.
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
hi @Anonymous
you can try something like this
someColumn =
VAR _currentString =
CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
RIGHT ( _currentString; LEN ( _currentString ) - 600 )
VAR _firstSpace =
SEARCH ( " "; _rightPartOfString ) - 1
RETURN
LEFT ( _currentString; 600 + _firstSpace )
This code expands the left function to the first space after character number 600.
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi Surla,
I'm facing a challange yet. When the long text has less than 600 characters.
Could you please help me!
Thanks,
Augusto
someColumn =
VAR _currentString =
CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
RIGHT ( _currentString; LEN ( _currentString ) - 600 )
VAR _firstSpace =
SEARCH ( " "; _rightPartOfString ) - 1
RETURN
IF (
LEN ( _currentstring ) <= 600;
_currentstring;
LEFT ( _currentString; 600 + _firstSpace )
)
Hi Dear Sturla,
Last night I tried the same approach as you posted above and got trhe same error message.
"An argument of function 'RIGHT' has the wrong data type or has an invalid value."
Thanks for your attention,
Augusto
try this
someColumn =
VAR _currentString =
CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
IF (
LEN ( _curentstring ) <= 600;
BLANK ();
RIGHT ( _currentString; LEN ( _currentString ) - 600 )
)
VAR _firstSpace =
IF ( ISBLANK ( _rightPartOfString ); 0; SEARCH ( " "; _rightPartOfString ) - 1 )
RETURN
IF (
LEN ( _currentstring ) <= 600;
_currentstring;
LEFT ( _currentString; 600 + _firstSpace )
)
Hi Dear Sturla,
You save me a lot of effort to get to a measure likes you provided.
Your solution works perfectly.
Thanks a lot.
Augusto
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |