Text calculations

Returns the categorical ordered intervals
BINS([Users Count], 10)
Returns provided date part of date as a text
DATENAME([Created On], 'year')
Returns first met value in a set
FIRST([Name])
Returns last met value in a set
LAST([Name])
Returns first N symbols of text
LEFT('Hulk', 2)
Converts text to lower case.
LOWER('Hulk')
Replaces text to be replaced in an income text expression with its replacement
REPLACE([Name], 'Suit', 'Helmet')
Returns last N symbols of text
RIGHT('Hulk', 2)
Splits values of text field using defined delimiter.
SPLIT([Tags], ',')
Returns provided numerical or date as a text
TEXT([Created On])
Combines all text values into one
TEXT_AGG([Feature])
Converts text to upper case.
UPPER('Hulk')