Measure to get the first value based on a dimension (and the opposite - the last!)

[Dayna]

Hello all,

Within QlikView, there was a function called 'FirstSortedValue', which looked something like firstsortedvalue(Quantity, Date). What this did was get the first value it could find for 'Quantity' sorted by Date. To get the reverse, the last value, it would be firstsortedvalue(Quantity, -Date).

What I'm trying to do is similar for some transactions based on the last transaction number (i.e. the highest number). 

How would I do this in PowerBI, please? I'd rather not group within the data transformation, as I'll need to do this for four different dimensions.

Many thanks,

Dayna

[johnt75 · Accepted solution]

You can use FIRSTNONBLANKVALUE() and LASTNONBLANKVALUE()