'Tableau equivalent for SQL aggregation with KEEP and FIRST/LAST

I need to get the first (or last) value in a given data subset.

For example, in Oracle this would correspond to using an aggregation function along with KEEP and FIRST/LAST:

MAX(desired_value) KEEP(DENSE_RANK LAST order by some_parameter_in_the_partition)

Where some_parameter_in_the_partition could be a date for example.

Now, wow to do this in Tableau Software? I can't find anything like that.

Thanks

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source