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, 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?
I would basically like to extract 15 characters, and if the string is longer than 15, add "..." at the end.
Solved! Go to Solution.
@Anonymous 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
@Anonymous 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
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 |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |