Hello.This is example of my table in database.How it's possible to get the last record for dimension Article column?
The result must be:
My idea was to use:set NeedQty = FirstSortedValue('Need Quantity' - 'Version No_');
But when there is the equal Version No. it's showing null.
Try =FirstSortedValue( aggr(max([Needed Quantity]),Article,[Version No.]), -aggr([Version No.],[Version No.],Article))
See attached qvw.
View solution in original post