Select n number of rows

[samueltphilip]

Hello,

Can I create a measure to return the last n number of elements in a text column ? I have an index column, can that somehow be used to fetch the row values.

[johnt75 · Accepted solution]

You can return the last 5 elements of the column as a comma separated list using

Last elements =
CONCATENATEX ( TOPN ( 5, 'Table', 'Table'[Index] ), 'Table'[Text column], ", " )