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.
Examples
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")}
In this example, the list was parameterized, and connect to a global text parameter containing a list of captions.
The parameterized list produced a button slicer, allowing the user to filter the query by the desired suffix:
