ENDS_WITH

Returns true if the field or expression ends with the specified text, otherwise returns false.

Sample usage

ENDS_WITH(Campaign, "Sale")

Syntax

ENDS_WITH(X, text)

Parameters

• X - a field or expression of any type.
• text - the text to find within X. text can be a field, expression, or literal value. text is case-sensitive.

Examples

Example formula	Data in	Output
ENDS_WITH(Campaign, "Sale")	Summer Sale	true
ENDS_WITH(Campaign, "Summer")	Summer Sale	false

Related resources

• Calculated fields
• Looker Studio function list