In a straight table you could add a calulated dimension along the lines of:
if(not isnull(aggr(max([Date of Account Name change]), [Meter No])), [Account Name])
and then ensure you tick the option 'Suppress When Value Is Null'
Then add a expression of '=1'. You can then hide the expresssion column on the presentation tab.
The other way would be to create a flag in the script that shows which Account name is the latest.
Create a mapping table by grouping your second table above by Account Name and Max(Date Of Account Name Change) Map this back into the second table. You can then compate the 2 dates and show which is the latest.
I think this problem is one of the kind "slowly changing dimension".
You might consider to have a look at the intervalmatch function.
But probably this is too much for that kind of your problem.
You may try as expression
=FirstSortedValue([Account Name], -1*date#([Date of Account Name change],'DD/MM/YY'))
To get only the latest account name.
P.S. date# is only needed in case [Date of ...] is not recognized as date format (as on my system).
Nachricht geändert durch swuehl
LossName.qvw 137.8 K