Ends With

Returns a subset of elements in a list based on a string search on captions. The search is based on a 'ends with" operation.

Syntax & Usage

• Configure the list that should be filtered.
• Add the Ends With block to the list block; in the Insert Arguments window, enter the search string.

Example

In this example, a list of Manufacturers was configured, and the search string "son" set in the Ends With block. The function returns Woolson:

{EndsWith({AllMembers([manufacturers].[Manufacturer])},"son")}