cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrejBI
Helper V
Helper V

How to extract the first X characters + "..."

Hi, I would like to use this function to calculate a column: 

 

 

 

Shortened URLs (limited) = 
IF
( LEN
(LEFT('Google Search Console - Summarized'[shortened URLs],15)) < 15,
 LEFT('Google Search Console - Summarized'[shortened URLs],15),
  LEFT('Google Search Console - Summarized'[shortened URLs],15) + "...")

 

 

 

yet it tells me that expression can't use variant data type. Is there a workaround for this? 

AndrejBI_1-1615559798032.png

I would basically like to extract 15 characters,  and if the string is longer than 15, add "..." at the end. 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

@AndrejBI I think it is the + in your formula instead of &.  Try it like this.

Column = 
VAR _Len = LEN ( 'Google Search Console - Summarized'[shortended URLs] )
VAR _URL = LEFT ( 'Google Search Console - Summarized'[shortended URLs],15)
VAR _Adder = IF ( _Len <= 15, "", "...")
RETURN _URL & _Adder

jdbuchanan71_0-1615560379102.png

 

View solution in original post

1 REPLY 1
jdbuchanan71
Super User II
Super User II

@AndrejBI I think it is the + in your formula instead of &.  Try it like this.

Column = 
VAR _Len = LEN ( 'Google Search Console - Summarized'[shortended URLs] )
VAR _URL = LEFT ( 'Google Search Console - Summarized'[shortended URLs],15)
VAR _Adder = IF ( _Len <= 15, "", "...")
RETURN _URL & _Adder

jdbuchanan71_0-1615560379102.png

 

View solution in original post

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