Set Analysis Max Date Record

[george55]

Hi all,

Need the max record, depending on the max date. See below.

Can not use something like that, because there is nothing to aggregate (for instance in Column "Sync_Key"):

Sum({$<%Date = {"$(=Max(%Date))"}>} Sync_Key)

Thanks.

%Date	User	Sync_Key
01.01.2020	Albert	Albert | 01.01.2020
02.01.2020	Albert	Albert | 02.01.2020
03.01.2020	Albert	Albert | 03.01.2020
01.01.2020	Stefan	Stefan | 01.01.2020
02.01.2020	Stefan	Stefan | 02.01.2020
Result:
%Date	User	Sync_Key
03.01.2020	Albert	Albert | 03.01.2020
02.01.2020	Stefan	Stefan | 02.01.2020

[sunny_talwar]

@george55 May be this

Dimension
User

Expression
FirstSortedValue(Sync_Key, -%Date)
Date(Max(%Date))

[george55]

Don't understand. These are to functions; where to put it? If I put only FirstSortedValue(Sync_Key, -%Date) in a separate Dimension, does not work

[sunny_talwar]

@george55 You need it as a dimension? Try this

User
Aggr(FirstSortedValue(Sync_Key, -%Date), User)
Aggr(Max(%Date), User)

[Chanty4u]

can you try this?

=sum({<%Date={"$(=Date(Max(%Date),'DD.MM.YYYY'))"}>}  sync_key)

Best

Chanty 

[george55]

Hi and thanks all of you, but none of these formula worked:

User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Error: not valid Dimension

Sum({<%Date={"$(=Date(Max(%Date),'DD.MM.YYYY'))"}>} Sync_Key)                     // Error: not valid Dimension

User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Syntax Error

FirstSortedValue(Sync_Key, -%Date) Date(Max(%Date))                                                // Syntax Error

Have only these 4 Dimensions in the Outputtable, no measures: